Crosstab Query with query parameter used to create a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My crosstab query using a query parameter works fine; however, once I try to
use it to create a report I am asked multiple times to re-enter my query
parameters.

The report generates the correct results; however, why do I need to re-enter
my query parameter multiple times??

Thanks..
 
Open the crosstab in design view, click on menu Query - Parameters. This
opens another window. Type in your parameter names and data type. Save.
 
Are there subreports or graphs used in your report?
IMHO parameter prompts are never acceptable user interface. You should use
references to values of controls on forms.

As Karl mentioned, you need to enter the data types of all parameters.
 
Back
Top