SQL Code- Records Between Two Dates

[eXhumed]

I am making a system for my auntie to help with a taxi firm. It records the details of each driver and also the earnings that each take each day (Sorted That Bit).

I have been having trouble trying to find a method around being able to print a report that can be customised by the user to be a summary of 1 selected Driver and earnings between two selected dates.

I heard that you can use SQL in my VB6 system with my access database. Is that possible?

If so, can i have any pointers on how to get it to work for me?

Thankyou,

Mykael

[GaryMazzone]

Are you going to use data controls (EVIL Things) or record set with ADODB?

[eXhumed]

I do believe that i am using AdoDB (Record Set) Links ^^ From what i have hear they are easier.

[GaryMazzone]

Then set the SQK statement that open the recordset with a condition of

Where fieldname Between #Date1# and #Date2#