INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Queries

Like Options by Bullschmidt
Posted: 23 May 03 (Edited 23 Jun 03)

All except blanks:
Like "*"

Starting with A:
Like "A*"
Or could do this: Like "a*"

A somewhere in the field:
Like "*A*"
Or could do this: Like "*a*"

One character an A or B or D:
Like "[A,B,D]"
Or could do this: Like "[a,b,d]"

One character A through C as the first character:
Like "[A-C]*"
Or could do this: Like "[a-c]*"

A through C as the 1st character and A through H as the 2nd character:
Like "[A-C][A-H]*"
Or could do this: Like "[a-c][a-h]*"

Starting with Sm, ending with th, and anything for the 3rd character:
Like "SM?TH"
Or could do this: Like "sm?th"

Digit for the 1st character:
Like "#*"
Or could do this: Like "[0-9]*"

Not in a range of letters:
Like "[!a-c]"

Not start with a range of letters:
Like "[!a-c]*"

Not start with a number:
Or could do this: Like "[!0-9]*"

Also the above Like expressions can be used as Validation Rule property of a field or control.

But the above type of things DO NOT work in the form of Between Blah And Blah.

J. Paul Schmidt, Freelance Access and ASP Developer
http://www.Bullschmidt.com/Login.asp - Database on the Web Demo
http://www.Bullschmidt.com/Access - Sample Access Invoices Database

Back to Microsoft: Access Other topics FAQ Index
Back to Microsoft: Access Other topics Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close