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

[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

 

[JK]

SELECT [Current Balance] FROM Customers
WHERE [Current Balance]>200;

 

[John Vinson]

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

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]

 

[aaron.kempf]

more importantly; don't use MDB for anything it has been obsolete for
TEN YEARS

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

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]