Is it possible to write comments, or comment out text in a SQL command, that Access will ignore but allow for explanation of what the command or query is doing.
Thanks
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
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
I am trying to use the LIKE to find the word green in any product name
The Table is PRODUCTS and column is ProductName
What I entered:
SELECT * FROM PRODUCTS
WHERE ProductName LIKE "%green%";
It doesn't work and I know that there are products that have green in the ProductName
What am I doing...
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.