View Full Version : Parameter Values in Queries


Savedra
01-11-2002, 09:15 PM
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
01-12-2002, 07:10 AM
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
01-16-2002, 06:45 AM
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.