Noreene Patrick
Registered User.
- Local time
- Yesterday, 22:32
- Joined
- Jul 18, 2002
- Messages
- 223
My report has a page for each day of the week. Example:
12/01/02- page 1
12/02/02 - page 2
and so on for an entire year.
My question is how do I open the report so that it will open on the current day, but allows me to go forward or backward to view other days if necessary?
In my query under "dates" (which is the table holding all the dates for the year) I put in the criteria line, =date() and the report opens to the current day but I cant go forward or backward. So I put in >=date() and it allows me to go forward but not backward.
If i put in <>date() it goes to the beginning of all the dates and I dont want to scroll through every day until I get to current day.
Any help would certainly be appreciated.
Thanks,
12/01/02- page 1
12/02/02 - page 2
and so on for an entire year.
My question is how do I open the report so that it will open on the current day, but allows me to go forward or backward to view other days if necessary?
In my query under "dates" (which is the table holding all the dates for the year) I put in the criteria line, =date() and the report opens to the current day but I cant go forward or backward. So I put in >=date() and it allows me to go forward but not backward.
If i put in <>date() it goes to the beginning of all the dates and I dont want to scroll through every day until I get to current day.
Any help would certainly be appreciated.
Thanks,
