Reports based on dates

[cdrewery]

I have a simple access db for a car booking system at work.

At the end of each month we sit down and go over all the bookings made and cross them off with the invoice for the car company which we use (we use 3 diffrent suppliers).

How do I do it so that we can click on a button the user will enter in a start date (1/1/05) enter in an end date (31/1/05) and a report will be produced.

Erm help?! I've searched adn searched and can't find an answer?!

 

[ShouldBeFishen]

Try using a >[date here]and<[date here] in the date colum of your query.
This will produce a msg box to fill in the dates required

 

[dhookom]

I would avoid using parameter prompts. Take a look at the information at

http://www.fontstuff.com/access/acctut08.htm

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]