Is it possible to accept a date input from a user for a report upon execution, pass the value to a query, have the query execute and generate a report using the query result? Hope that makes sense.

I have a working query to generate output, but I haven't been able to think of a way change the date parameter without going into the design view and create a formatted view for the output.

Thanks in advance.

How about using the Parameter in the Report Design View?

Herru

Well, this is sort of strange. A report is a passive entity. It gives back to you information that you collected in a table. The information you got in the table was generated by a query or entered. The way the user gets to all of that is via a form.

You don't enter data into a report. A report is one way: out (to the screen or printer). Therefore, the place to ask for the date and execute the query is at the form. Enter the date at the form, then the form runs the query which accesses the table. When it's done, the form then opens the report with the correct recordsource.

Entering the date in a form should be very easy. Then the user can either click or button you can put an AfterUpdate event on the date field.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Use a parameter query to prompt the user for a date value. Use the query for the report.
If you do not know how to do that, Paste your SQL from your query and I will show you.


Sal