Unwanted parameter Box

[John thomas]

I have a query that runs great ,unfortunatelywhen ever i run it a parameter box shows .It refers to the total which is a calculated field .

I am using grouping The calculated field is Total: Sum([Soldatprice]*[quantity])
and instead of group it shows Expresion

 

[plog]

What is the text in the parameter box? That will tell you what field it is unable to resolve.

Most likely you are referencing a calculated field in that query in another spot:

CalculatedField: [Field1] + [Field2]
BrokenField: [CalculatedField]*2

The first one(CalculatedField) is fine because its built on fields that exist outside the query. The second (BrokenField) breaks because its referencing a field (CalculatedField) that doesn't exist outside the query. You can't calculate a field then immediately use it elsewhere in the query.

 

[John thomas]

Hi text referenced is total .
Total: Sum([Soldatprice]*[quantity])
both sold at price and quantity are stored in my order details table

 

[JHB]

The problem is that you are grouping the calculated value, (the Total), set it to Expression.