how do i exclude fields with certain characters

  • Thread starter Thread starter ns
  • Start date Start date
N

ns

I have a field containing titles of books. I want to exclude records that
contain the specific characters "AFE". Help
 
You don't give enough inforamation to give a specific answer, but if you mean
exclude all records that contain the value AFE in a query, it would be in the
Where clause of the query:
WHERE [FieldName] NOT LIKE "*AFE*"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Special characters 3
How do I exclude records based on first two characters in cell 6
excluding 12:00:00 AM from query results 4
Access Remove rows based on multiple fields 2
Create a query when table has a look up in it 3
Excluding Fields in Reports 2
Exclude an ID from a Group 1
pattern matching and exclusion 5

Back
Top