maintainig database history in ms access using VB 6.0

[Amir.php]

I recently working on the project of Car Showroom management system in VB.
I want to keep maintain a history of all the transactions(such as sales/purhase etc) and want to retrieve any particular transaction stored in history.
As same like a internet explorer Todays, weakly, or monthly.
can anyone help me?
it is very necessary for me.
Thank in advance.

[redhat]

Do you want help creating the Database or you need help connecting the back-end to the program?
For the DB, use SQL and connect via ADODC in VB 6.0
Use a query, to check the transaction date with current date, and retrieve rows...