Trying To use SQL BETWEEN command

[CasitaProgrammer]

I am trying to sort PRODUCTS table ListPrice column with ListPrice values between $15.00 and $20.00.
I enter:
SELECT * FROM PRODUCTS
WHERE ListPrice
BETWEEN "$15.00" AND "$20.00";

I keep getting error wrong criteria window

 

[Pelerin13]

what is the data type for your field ListPrice ?

 

[CasitaProgrammer]

The data type is currency

 

[boblarson]

See if this works better:

BETWEEN 15 AND 20;

(and you don't put anything in quotes if it isn't text. Dates get octothorpes (#) and numbers get nothing)

 

[CasitaProgrammer]

It worked in seconds. It is amazing when the correct data is entered.
I am just beginning to learn Access and SQL

How do I go in and edit info for CasitaProgrammer?
KW

 

[boblarson]

How do I go in and edit info for CasitaProgrammer?

Go to the top left menu bar of the forum and click on the USER CP link. CP means control panel.