[RESOLVED] Select By Date

[Dbee]

I got a database that has 492 records in it I am trying to extract from that database by employee Number, date. need to do this by day so I can display there time in a flexgrid.

For a set period of time like 9-22-2008 to 10-5-2008

I know there is a set method for doing this just wondering if I use recordset or another call.

Would I have to call the select data needed By employee number and date.

As it is I am scanning the entire database to get these records.



Tryed Using This

Dim Acct$, Days$
Set Record_Sets = New ADODB.Recordset
Acct = RRR!Number
Days$ = Trim(Str(D))
Record_Sets.Open "SELECT Start_Day,Start_Time,Stop_Time,Hours,Min,Overtime from Pay_Hours WHERE Account = '" & Acct & "' ORDER BY " & Days & "'", Data_Connection(1), adOpenStatic, adLockReadOnly, adCmdText