How to enter SQL command in Access

[CasitaProgrammer]

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.

 

[HiTechCoach]

On the tabs click on "Create" then click "Query Design"

You might find some helpful videos here:
http://www.youtube.com/learnaccessbycrystal

 

[CasitaProgrammer]

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.

 

[vbaInet]

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.

 

[CasitaProgrammer]

Thanks, it worked like a charm!

 

[vbaInet]

Thanks, it worked like a charm!

You casted the right spell!

 

[CasitaProgrammer]

It worked like a charm!

 

[CasitaProgrammer]

It worked like a charm! Thanks