delete query with more than 1 criteria not to delete

[afs24]

I creating a delete query but do not want to delete certain entries. Im trying to delete the event feild except for three entries. This is what the feild and criteria looks like. What else could I do?

EVENTS
front loading
home sale
50% off sale
shoe sale

crieteria: not "front loading" or not "home sale" or not "50% off sale"

this is not working or me.....It deletes everything....I can only make one crieteria selection for it to work.

 

[Dugantrain]

Try putting each criteria on a separate criteria line in the Query Builder:

NOT "front loading"
        or
NOT "home sale"
        or
NOT "50% off sale"

 

[afs24]

I tried it but it's not working?

 

[Dugantrain]

Oh, wait, instead of:

not "front loading" or not "home sale" or not "50% off sale"

try:

not "front loading" AND not "home sale" AND not "50% off sale"

Note: "Or" and "And" in SQL is counter-intuitive. They way you use these words in normal speech and the way they are used in SQL is exactly the opposite!

 

[SydneyGeek]

You could try another syntax:

Not In("front loading","home sale","50% off sale")

This often simplifies the logic (for me, anyway)