Simple Delete Query

  • Thread starter Thread starter SITCFanTN
  • Start date Start date
S

SITCFanTN

I have a table that includes the field titled "State". I want to delete all
records in a table except records that have "AZ", "CT" or "NY" in the state
field. I have tried the criteria of =Not "AZ" or"CT or "NY", but I'm not
getting the correct results. I only retain AZ records. Any help you can
provide is appreciated, thank you.
 
SITCFanTN said:
I have a table that includes the field titled "State". I want to delete
all
records in a table except records that have "AZ", "CT" or "NY" in the
state
field. I have tried the criteria of =Not "AZ" or"CT or "NY", but I'm not
getting the correct results. I only retain AZ records. Any help you can
provide is appreciated, thank you.
Click to expand...


Try this:

DELETE FROM [YourTableName]
WHERE [State] Not In('AZ', 'CT', 'NY')
 
Not "AZ" or Not "CT" or Not "NY"

This is cleaner:

Not In ("AZ", "CT", "NY")

Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
 
Not "AZ" or Not "CT" or Not "NY"
Click to expand...

Sleepy, Jerry? <g>

That should be "AND" rather than "OR" - "AZ" is in fact Not "NY", so this
criterion will delete all records in the table!
This is cleaner:

Not In ("AZ", "CT", "NY")
Click to expand...

Absolutely better.
 
Looks like I need a brain reboot. One dope-slap self-applied to the head.

Thanks John!
 
Back
Top