Enter parameter value which should not exist

C

ChuckW

Hi,

I have created a two query SalesbyState1 and
SalesbyState2. I then created a report called
SalesByState that runs off the results of SalesByState2.
The problem is that whenever I run the report, a box
comes up that says "Enter Paramter Value
Query1.SumofSubtotal". SumOfSubtotal is the name of one
of my fields in SalesByState2. When I click OK the report
is shown without any fields missing. I can seem to get
rid of this annoying box. I am not missing fields and
the report is running correctly. I tried sorting the
query and report different ways but am still receiving
errors.

Can anyone help?

Thanks,

Chuck
 
J

Joan Wild

Check the Sorting and Grouping dialog in the report design; check in your
queries (both SalesbyState2 and 1) for this field - don't forget to check in
Query, Parameters dialog.
 

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

Enter Parameter Value keeps appearing 1
Enter Parameter Value 4
Enter parameter value Query1. ... 3
Too Many Parameter Prompts 1
Enter Parameter Value Dialog Box 2
'Enter Parameter Value' 4
formula requires parameter in error 2
parameter query prompting multiple times 5

Top