Search results

  1. C

    Commenting in a SQL command

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

    Trying To use SQL BETWEEN command

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

    SQL LIKE command

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

    How to enter SQL command in Access

    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.
Back
Top Bottom