Rerun query

[Jamie Dickerson]

I have a report based on a query. On opening the report you are prompted to
enter 3 parameters (start date, end date, employee name). I need to run a
seperate report for each employee. Is there anyway to code or create a macro
that tells the report to reopen with new parameters upon closing or printing.
I am trying to avoid opeing the report 80 times.

 

[KARL DEWEY]

I think an easier way would be to add a Report field in your employee table ,
Yes/No, and use a form with start date & end date in the header and employees
listed in datasheet view to check who to use in report. Add a button to run
report.

 

[Jeff Boyce]

Jamie

Just a thought, but if you removed the parameter that prompts for the
employee, then modified the report to put each employee's data on a separate
page, would that accomplish what you're after?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.