Variable Date on Reports,HOW

[rmason]

Hi,
I have a DB that now has about 4 months worth of Data, I am about ready to turn the DB over to the user who will producing reports. She will be running a report with different months at different times by entering a Beginning date and then a ending date (Always a month at a time) Is the a way to have the month appear on the report without "Hardcoding" it in design view?

Example: If she enters Beg.Date Ending Date
20030401 20030430

I would like the report title to be: EMR for 040103 - 043003

I hope this can be done, Thanks in advance. Rick

 

[Rich]

If you used a pop up form to enter the parameters you could just set a textbox control source to the form

 

[rmason]

Dates

Hi Rich,
I am not using a form, I import data via a text file and Reports are run based on queries.

 

[sha7jpm]

place a parameter in the query design

think this might be what you are after.. (nb. it might have been Rich who told me about this in the first place!)

on the design view of the query you are creating. in the two boxes that you have the user type in the criteria put the following such as.. [please enter beginning month]

then in a textbox on your report type exactly the same in the control source.. [please enter beginning month]

the report will pick up the value for you..

hope this helps.

john.

 

[rmason]

THANKS!!!!

That did it guys, Thanks for the feedback!