Delete Query

[mrz via AccessMonster.com]

Hello All,

I have a SS#, Last, First, Source, Dept, ZipCode table.
I noticed I have duplicate people. e.g.

ss last first source dept zip
123456789 WALTERS GEORGE TL SOCIAL SCIENCE 10805
123456789 WALTERS GEORGE TL SOCIAL SCIENCE 10805-2633

As you can see george is there twice because he has two types of zip codes
althought it is the same.

I need to be able to run a delete query that will kill the single zip code.
How do i do that?

I am not familiar with SQL statement. I am in the design wiew.
Is the delete query my answer? or can this be done in another way?

Please let me know.

Thanks,
MRZ

 

[mrz via AccessMonster.com]

I am giving it a try...I was able to create the delete query however. I do
not know what to put on the
criteria. what should be my criteria under WHERE?

Thanks everyone...

 

[mrz via AccessMonster.com]

I just realize something else. I just do not want to delete everything.

check this out.

ss last first dept zip source
123456789 ALDRICH TOMARA ENGLISH 11215 TL
123456789 ALDRICH TOMARA ENGLISH 11215 TL

In this case I don't want to delete tomora completely... I want to only
delete one instance since her zip is fine
PLEASE SOMEONE REPLY WITH THE EXPRESSION FOR THE CRITERIA

I am giving it a try...I was able to create the delete query however. I do
not know what to put on the
criteria. what should be my criteria under WHERE?

Thanks everyone...

Hello All,

[quoted text clipped - 18 lines]

Thanks,
MRZ