Web Development

Ask something
Discussion Locked

Access 2000 Report Date

0 helpful
3 replies

by djpinson

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Access 2000 Report Date
I'm trying to run a report on entries by month. I need to be prompted for a date range i.e. "between 1/01/01 and 1/31/01" when I go to run the report. I'm able to to get this info in the query, by entering the statement in criteria, but it should be run at the report level. Any suggestions?? This is Access 2000 running a report.

3 replies

by sue.ritter

Creat a query to run your report from. Use the Between [Enter Beginning Date] And [Enter End Date] as the criteria for the date field you choose. Then in the report create a text box that says [Enter Beginning Date] and [Enter End Date]. On my reports I always put a "thru" between the two boxes so it would appear as 1/01/01 thru 1/31/01 or else you could put "Between" in front and an "and" between them to say Between 1/01/01 and 1/31/01.

This discussion is closed to new replies.