Using Criterion to add begin/end date range. how get on report

stoka

Getting Better
Local time
Yesterday, 18:16
Joined
Jan 22, 2007
Messages
23
I am using a simple " >= [BeginDate:] and <= [EndDate:]" in the criterion section of a query to allow a date range to be selected in the query which is used in a report. How can i get that [BeginDate:] and [EndDate:] info available to print on the report so it shows the actual date range being displayed in the report ? thanks.
 
Use a form instead of prompts in a query. See attached sample I created for you to help show how.
 

Attachments

sample database

thanks so much. the sample helped me understand how it works. i have posted another question about using sorting and totaling option selections on that form and passing them to the report....i tried to do a comment back about your help but it said i needed to spread it around first...don't know how to make it work to get to respond to your assistance.
 

Users who are viewing this thread

Back
Top Bottom