field contains " "

K

Katia

I would like to search within a category using the
command; field contains "x". How do I do this?
 
T

Tom Ellison

Dear Katia:

For the Jet database engine, use:

LIKE "*x*"

For MSDE use:

LIKE '%x%'

This is case INsensitive.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Top