Repeating Query Parameter in Report

C

Chris Brown

I have a report that is based on a crosstab query that is based on a query
that has start and end date parameters. When I run either the child or parent
query everything works fine; it asks for the start and end dates and displays
the data. When I run the report, it asks the same parameter questions 3
times! The report looks great but I can't fugure out why it keep asking for
the parameters.
Any suggestions are appreciated.
 
K

KARL DEWEY

Use an unbound form with unbound text boxes to enter parameters and reference
the text box in the queries.
 
C

Chris Brown

Thanks much Karl, great idea!

KARL DEWEY said:
Use an unbound form with unbound text boxes to enter parameters and reference
the text box in the queries.
Click to expand...
 

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

Similar Threads

Parameter Query Won't Run 0
crosstab query with parameter query 5
Parameter Queries in Crosstab Query 2
Parameter Query - Report 4
Parameter Query 1
Duplicate prompts in crosstab query and subsequent report 1
Report from a Crosstab w/Parameters 1
parameter query 13

Top