Query criteria not working

thart21

Registered User.
Local time
Yesterday, 17:20
Joined
Jun 18, 2002
Messages
236
Does anyone know why this is not working for me?

I am trying to change a query to add additional criteria and the records that I am trying to exclude keep showing up.

Original query

Field - "otherloc"
Criteria - <>"Supplies forecast" Or Is Null
New Criteria - <>"Supplies forecast" Or Is Null Or <> "PO*"

I am trying to tell it to exclude any record in which "PO" is the first term in the field. The data in the fields in my main table are like PO 702968.

I have tried changing it to PO702968 but nothing seems to matter, the records won't go away. I also tried to duplicate all of the criteria in my query on a second line and add the new criteria and I get the same results.

I've never seen this before and I can't figure out why it would be doing this.

Thanks
 
I can't believe I figured this out right after my post - after an hour of research!
Sorry for the false alarm:
Corrected criteria
Not ("Supplies forecast" Or Like "PO*") Or Is Null

Thanks,

Toni
 

Users who are viewing this thread

Back
Top Bottom