Query returns parameter value required........

[Trial & Error]

I have a query that is setup with the group by total, and many of the fields
set to SUM.

I have been using these sum totals to generate charts in both forms and on
reports.
One chart is supposed to show 2 styles of rental equipment vs the number of
clients.
In order for this chart to work, i need a field on my query that would
contain the # of nonrentals.

I enter an expr. in an extra column on the query... and when it runs, the
parameter entry windows pop up... 1 window for each field mentioned within
the expression. If i just hit enter, the query runs perfectly and the expr.
returns the correct value.... but I dont want the prompts to display. I just
want the query to run, the expression to calculate the value, and the results
to show.

 

[Barry]

This parameter is being looked for because the query can not find the field
you used in your expression

What is the expression you used in your query to calculate this value?