Exclude certain records in query

C

CEV

I have a query that includes a field called PositionTitle. I want the query
to find all records except for anything in the PositionTitle field that
begins with L. What would I put in the Criteria field in order to do this?

Thanks,

Chad
 
J

Jason Lepack

I have a query that includes a field called PositionTitle. I want the query
to find all records except for anything in the PositionTitle field that
begins with L. What would I put in the Criteria field in order to do this?

Thanks,

Chad
Click to expand...

like "L*"
 
K

Klatuu

Actually, it would be
Not LIKE "L*"
to return all records that do not start with the letter L in the field.
 
Top