Parameter Values in Queries

[Savedra]

I record daily deposits (DepositAmount) and withdrawals (WithdrawalAmount) in a cashbox database for different currencies. If I run a query for monthly totals I am prompted to “Enter Parameter Value” for the field “Sum Of WithdrawalAmount” and ”Sum Of DepositAmount". I don’t enter anything, just click ok and I get the right results, but the pop-up windows are disturbing. Please help.

 

[pcs]

sounds like you might have a couple of 'artifact' fields in you query.

it might be helpful if you post the query SQL.

al

 

[Fizzio]

On your Query design, check the parameters of the query. (Right Click on Tables Section - Parameters) and see if these parameters are there. If the query works with no values, you can probably safely delete them.