SQL Code- Records Between Two Dates
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
Re: SQL Code- Records Between Two Dates
Are you going to use data controls (EVIL Things) or record set with ADODB?
Re: SQL Code- Records Between Two Dates
I do believe that i am using AdoDB (Record Set) Links ^^ From what i have hear they are easier.
Re: SQL Code- Records Between Two Dates
Then set the SQK statement that open the recordset with a condition of
Where fieldname Between #Date1# and #Date2#