"Enter Parameter Value"

  • Thread starter Thread starter sst
  • Start date Start date
S

sst

I have a select query which summarizes the information by customer in two
fields. These fields give me the sum of the amount purchased and the amount
paid in order to calculate the balance due. When I open this query (or any
reports based on this query) I get the "Enter Parameter Value" error message.
I can simply enter through these boxes and the query runs fine. Any ideas
why I am getting these messages and what I can do to correct them. I have
searched my expressions and can find nothing wrong, but maybe I am missing
something.
 
sst said:
I have a select query which summarizes the information by customer in two
fields. These fields give me the sum of the amount purchased and the
amount
paid in order to calculate the balance due. When I open this query (or
any
reports based on this query) I get the "Enter Parameter Value" error
message.
I can simply enter through these boxes and the query runs fine. Any ideas
why I am getting these messages and what I can do to correct them. I have
searched my expressions and can find nothing wrong, but maybe I am missing
something.
Click to expand...


And what parameter value is it asking you for? The name of the parameter
it's looking for should be right there in the dialog box. Most likely you
have misspelled a field name, or maybe a field was removed from the table,
or renamed, after you built the query.
 
I used the query wizard to find the sum of two fields. Those fields are now
named "Sum of Total_Purchases" and "Sum of Amount_Paid". I then added a
field named "Balance Due." The formula for that field is Balance_Due: [Sum
of Total_Purchase] - [Sum of Amount_Paid]. I am getting 2 parameter boxes
that are asking to enter the Sum of Total_Purchase and Sum of Amount_Paid
 
I used the query wizard to find the sum of two fields. Those fields are now
named "Sum of Total_Purchases" and "Sum of Amount_Paid". I then added a
field named "Balance Due." The formula for that field is Balance_Due: [Sum
of Total_Purchase] - [Sum of Amount_Paid]. I am getting 2 parameter boxes
that are asking to enter the Sum of Total_Purchase and Sum of Amount_Paid
Click to expand...

We cannot see your query, sst.

My GUESS is that you're running into a feature of queries: you cannot
(usually) base a calculated expression on *another* calculated expression.
Instead you'll need to recapitulate the calculation: e.g.

Balance Due: Sum([Total_Purchase] - Sum([Amount_Paid])

or whatever expressions you used to calculate those fields.
 
sst said:
I have a select query which summarizes the information by customer in two
fields. These fields give me the sum of the amount purchased and the
amount
paid in order to calculate the balance due. When I open this query (or
any
reports based on this query) I get the "Enter Parameter Value" error
message.
I can simply enter through these boxes and the query runs fine. Any ideas
why I am getting these messages and what I can do to correct them. I have
searched my expressions and can find nothing wrong, but maybe I am missing
something.
Click to expand...
 
Back
Top