Report asks for same paramaters three times

[mariaw]

Hi

I have a report that I have to generate from two queries (I cannot put them into one query because it doesn't work for very complicated reasons....)

Anyway - both queries ask for a parameter query to be entered (which is a start and an end date). When I run the report, obviously, it asks for the dates to be entered, but it asks three times.....(not sure why it doesn't only ask for them twice...)

So - I want the report to generate using the same criteria for each query....how can I get the report to just ask for the information once???

Thanks

Maria

 

[KeithG]

Create an unbound from with two text boxes on it txtStartDt and txtEndDt. Then in your queries instead of having between [Start Date] and [End Date] put Forms![NameOfForm]!txtStartDt and Forms![NameOfForm]!txtEndDt

Now the queries will reference the text boxes on your form for the dates. Make sure your form is open when you run the query.

 

[mariaw]

Query asks for parameters three times

Thank you so much Keith G (and Pat Hartman!) it has worked - sorry for the late reply, but have been on holiday!

Cheers

Maria