Print date criteria

[tish]

I have a query ("OMB Figures") that I'm pulling into "OMB Form". The criteria
I have in the query is Between 8/1/08 and 8/31/08. How do I print whatever
date range is on the query on the form? I have seen the answers for getting
the date criteria to print when the query is set up to actually prompt the
user for a date range, but I have not set up the query this way (basically,
I'm getting errors that I can't figure out how to fix right now when I set it
up that way. Also, I'm just curious.)

Help? I'm dashing this response off pretty quickly, so please let me know if
I've forgotten some vital piece of info..!

 

[Jeff Boyce]

I believe the problem is that Access doesn't bother "remembering" those
parameters once it's finished setting up the query.

There's a couple ways to keep that information around...

One is to make EXACTLY the same parameter prompts in the report definition.
You probably will only need to enter the value(s) once.

The other way is to use a form to "gather" the parameters, and have your
query (and your report) "look" at the form to get the values, with something
like:

Between Forms!YourFormName!YourFirstControl And
Forms!YourFormName!YourSecondControl

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP