How do I exclude records based on first two characters in cell

  • Thread starter Thread starter Wheelz
  • Start date Start date
W

Wheelz

I need to modify an ACCESS query to exclude records if the first two
characters in a certain field begin with "AA". I should know how to
specify this simple thing but I don't. I would appreciate your
feedback.

Ken
 
I need to modify an ACCESS query to exclude records if the first two
characters in a certain field begin with "AA". I should know how to
specify this simple thing but I don't. I would appreciate your
feedback.

Ken
Click to expand...
As criteria on that column, write:
Not Like "AA*"
 
Coming back to the well once more:

How might I specify that I want to exclude ant record that has CDMA
anywhere in a string in a spefic column?
 
not like "*CDMA*"


--
Rick B



Wheelz said:
Coming back to the well once more:

How might I specify that I want to exclude ant record that has CDMA
anywhere in a string in a spefic column?
Click to expand...
 

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

how do i exclude fields with certain characters 1
Access Remove rows based on multiple fields 2
Create a query when table has a look up in it 3
Exclude Null Values/records from Report 1
How do I exclude if text string inside string - ACCESS 1
Excluding records 2
Query criteria - exclude data and return all records if null 3
Searching through list box based on query 2

Back
Top