field contains " "

  • Thread starter Thread starter Katia
  • Start date Start date
K

Katia

I would like to search within a category using the
command; field contains "x". How do I do this?
 
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
 
Back
Top