Enter parameter value which should not exist

  • Thread starter Thread starter ChuckW
  • Start date Start date
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
 
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.
 
Back
Top