Multiple Parameters

T

Tony Montana

I have seen this posted before but cannot get the code to work for my report.
I'm still only a novice. I have a report based on a query that shows 5
charts. When I run the report it asks for the date or any other parameter
that I select 5 times. How can I get the report to run with the parameter
only being asked for once like in the query. I have a report which is run by
a date range, and a report which is run by a field called Outbase.

Huge thanks in advance as this will save me so much time.......
 
N

NetworkTrade

well one method would be to create a little form or use an open form - and
put that date in an unbound text box that serves the purpose of holding that
date.

or on the otherhand perhaps you have already an open form with that date there

put the criteria for those queries to be the field of that form:
Forms!FormName.FieldName

this way the query will look to the form for that data and not to you....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top