How to enter SQL command in Access

CasitaProgrammer

Registered User.
Local time
Today, 03:42
Joined
Mar 20, 2011
Messages
13
I have commands that I want to enter in Access 2010 but do not know how to get to the entry screen. Need step by step guide.
 
Thanks, I have been able to enter several SQL SELECT commands but am having trouble with one where I want to select the QuantityOnHand when it is less than or equal to ReorderLevel
This is what I entered:
SELECT * FROM PRODUCTS
WHERE QuantityOnHand <= "ReorderLevel"

It doesn't work for some reason.
 
Is Reorderlevel a field in the Products table?

If this is the case then the last line should be:

WHERE QuantityOnHand <= [ReorderLevel]

It will not work if either of the fields is not a Number data type.
 

Users who are viewing this thread

Back
Top Bottom