How would you display the following criteria when writing a query?
Either viewing the Datasheet view or Run the Query.
Show values in a field that is not empty?
Use the value - IS NOT NULL
Show dates that are between May 1, 2009 and May 22, 2009.
Use - BETWEEN #date# and #date#
Show a list of cities called Weston, Southwest Ranches and Davie.
Use - In ("Weston", "Southwest Ranches","Davie")
Show a city that that starts with the Wes.
Use - LIKE "Wes"
Show any students who last name is Rodriquez or Smith.
Use - "Rodriquez" OR "Smith"
Show all states that are not equal to FL.
Use - <>"FL"
Show all studetnts who are over the age of 16.
Use - > 16
Show all fiels that are empty.
Use - Is Null
Show all ages that are greater than or equal to 18.
Use - >= 16
Tuesday, May 12, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment