Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access

ResolvedVersion 2003

Tina has attended:
Access Introduction course

Access

Would like a list of query symbols

RE: Access

Hi Tina,

Thank you for your request.

Please find below the different query comparison operators:

<> Not equal to
> Greater than
< Less than
>= Greater than or equal to
<= Less than or equal to
BETWEEN ... AND ... - Range of values inclusive
NULL - Where there are blanks in the field
NOT - Excluding values from the results
* - Wildcard, so s*, any fields beginning with S

I hope this fulfills your request.

Regards

Simon

Access tip:

Add current time to a field

Press CTRL+SHIFT+ SEMICOLON

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.