I have a couple of reports that I need to print for specified dates, what is the easiest method to be able to put a start and end date in to print that range only.
I know this is an easy one, I am new to using Access.
in the criteria portion of the query that the report is based on you can put
Code:
between #1/1/2004# and now()
Not sure if that is what you are looking for. If you want to do it from a form, you can have users enter a start date in one text field and an end date in another and then use those fields in your query for the report.
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]
[blue]Ask me about my grandson, get a grand answer.[/blue]
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.