MS Access 2000: Query Any Part Of Field

[mikeiswayawesome]

I am trying to query a field of a table for any part rather than the whole. I have no idea how to code this. I assume that I need to use the expression builder. If someone out there could help me I sure would appreciate it.

 

[SkipVought]

Hi,

Try criteria
[tt]
LIKE '%x%'
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[fneily]

Should be posted in: Microsoft: Access Queries and JET SQL

Or - Like *whatever*

whatever is whatever you want to look for.