Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I know this is basic for date printing 2

Status
Not open for further replies.

acarr2032

Programmer
Oct 4, 2004
18
0
0
US
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.

Thanks.
 
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.
 
If you want this to be dynamic, I suggest using a form to enter the dates. There is some information at
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]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top