why does "enter parameter values" pop up in SQL query in Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to get "current balance" out of my field CURRENT BALANCE. When I query
this in a SQL clause, a pop up comes and says "enter parameter value".
I am using this. SELECT current balance
FROM customers
WHERE current balance > 200;

When I run this, the parameter box pops up. Thanks
 
I want to get "current balance" out of my field CURRENT BALANCE. When I query
this in a SQL clause, a pop up comes and says "enter parameter value".
I am using this. SELECT current balance
FROM customers
WHERE current balance > 200;

When I run this, the parameter box pops up. Thanks
Click to expand...

Blanks are important. It's looking for a parameter named "current" and
another parameter named "balance".

If (unwisely, IMO) you use blanks in fieldnames you must, no option,
enclose the fieldname in square brackets:

SELECT [Current balance]
FROM customers
WHERE [Current balance] > 200;

John W. Vinson[MVP]
 
more importantly; don't use MDB for anything it has been obsolete for
TEN YEARS




John said:
I want to get "current balance" out of my field CURRENT BALANCE. When I query
this in a SQL clause, a pop up comes and says "enter parameter value".
I am using this. SELECT current balance
FROM customers
WHERE current balance > 200;

When I run this, the parameter box pops up. Thanks
Click to expand...

Blanks are important. It's looking for a parameter named "current" and
another parameter named "balance".

If (unwisely, IMO) you use blanks in fieldnames you must, no option,
enclose the fieldname in square brackets:

SELECT [Current balance]
FROM customers
WHERE [Current balance] > 200;

John W. Vinson[MVP]
Click to expand...
 
Back
Top