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