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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date parameter for Report query 1

Status
Not open for further replies.

foxrainer

Programmer
Jan 10, 2002
270
US
I have a table with a "occuranceDATE" DateTime field

I would like the report to print all records which fall between two dates.

How can I build the date into the Report Query builder and have it be a parameter (i.e.: dates will change)

I don't mind having the parameter window pop up asking for the parameter.

Any help would be appreciated.
 
In the criteria of occuranceDate put this:

Between [Enter the beginning date] AND [Enter the ending date]

HTH
Mike

[noevil]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top