Exclude certain records in query

  • Thread starter Thread starter CEV
  • Start date Start date
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
 
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*"
 
Actually, it would be
Not LIKE "L*"
to return all records that do not start with the letter L in the field.
 
Back
Top