Filtering.

A

Austin Powers

I exported my Outlook calendar to an Access file. the file has field such
as Start date, End date, Description, and Categories etc.

The category field has date such as:

Massachusetts;Real Social Dynamics;Boston;USA
Lair Meeting;Las Vegas;Nevada;USA
DocAndWriter;Japan;Tokyo
New York;New York City;PickUp 101;USA

I'd like to be able to create a filter that will show, for example, all the
records that have "USA' in them, or 'USA' and 'Las Vegas'.

How might you suggest I go about this?

Thanks.
 
J

John Vinson

I exported my Outlook calendar to an Access file. the file has field such
as Start date, End date, Description, and Categories etc.

The category field has date such as:

Massachusetts;Real Social Dynamics;Boston;USA
Lair Meeting;Las Vegas;Nevada;USA
DocAndWriter;Japan;Tokyo
New York;New York City;PickUp 101;USA

I'd like to be able to create a filter that will show, for example, all the
records that have "USA' in them,
Click to expand...

[Category] LIKE "*USA*"

or 'USA' and 'Las Vegas'.

[Category] LIKE "*USA*" AND [Category] LIKE "*Las Vegas*"

(which may well pick up a reference or two to Las Vegas, New Mexico or
even the tiny Las Vegas, California)


John W. Vinson[MVP]
 
Top