Filtering.

[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.

 

[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,

[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]