Delete Dupes

[comfygringo]

I can't get this query to work:

DELETE Valid_Numbers.[Last Name], Valid_Numbers.[First Name], Valid_Numbers.[House Number], Valid_Numbers.Dir, Valid_Numbers.[Street Name], Valid_Numbers.Apt, Valid_Numbers.City, Valid_Numbers.ST, Valid_Numbers.ZIP, Valid_Numbers.[Area Code], Valid_Numbers.Phone, Valid_Numbers.[Purchase Date], Valid_Numbers.[Purchase Amount], Valid_Numbers.[Date of Birth], Valid_Numbers.[Mortgage Year]FROM Valid_Numbers
GROUP BY Valid_Numbers.[Last Name], Valid_Numbers.[First Name], Valid_Numbers.[House Number], Valid_Numbers.Dir, Valid_Numbers.[Street Name], Valid_Numbers.Apt, Valid_Numbers.City, Valid_Numbers.ST, Valid_Numbers.ZIP, Valid_Numbers.[Area Code], Valid_Numbers.Phone, Valid_Numbers.[Purchase Date], Valid_Numbers.[Purchase Amount], Valid_Numbers.[Date of Birth], Valid_Numbers.[Mortgage Year]
HAVING (((Count(Valid_Numbers.ZIP))>1));

Any thoughts?

[orange]

You Delete records not Fields.

Why do you have duplicates?

See if this helps
http://www.techrepublic.com/article/...-access-query/

Good luck