Access – Query Definitions

Posted on | October 6, 2010 | 1 Comment

Query Definitions
<> <> “Expired”
<= <=100
Between Between 1000 and 5000
Like “S*” Starts with S
Not Like “S*” Does not start with S
IsNull Empty
And Like “P*” and Not Like “*I”
Or “Km” or “Mts” or “Cm”
In In (“Km”,”Mts”,”Cm”)
Date function Between Date () and Date()+30
[] Parameter Query,  Example [Enter your name]

Comments

One Response to “Access – Query Definitions”

  1. Dhanesh
    October 17th, 2012 @ 2:46 am

    Hi,

    I am dhanesh working as reporting analyst need to learn VBA with access

    mb9710916723

Leave a Reply