Crosstab Query with query parameter used to create a report

J

JJ_Access

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..
 
K

KARL DEWEY

Open the crosstab in design view, click on menu Query - Parameters. This
opens another window. Type in your parameter names and data type. Save.
 
D

Duane Hookom

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.
 

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