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

I have a query that is setup with the group by total, and many of the fields
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6877-query-returns-parameter-value-required.html
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6877
to show.

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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?

"Trial & Error" wrote:

> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6877
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6877
> 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.