Search results

That sucks. Thanks

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

The data type is currency

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

Thanks, I had tried different variations for an hour and you solved the problem in seconds. Thanks:)

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...

It worked like a charm! Thanks

It worked like a charm!

Thanks, it worked like a charm!

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.

Hello, I am really not yet in the boat, feel like I am drowning and watching the dingy float away. 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.