Access 2003 Table Duplicate Records Removal

Hello Experts,  I have an Access 2003 table that has a field called period which contains 2 digit numbers.  I.e 25,26,27,28,29,etc...etc...  I need a SQL statement that will remove the records based on the 2 digit number.  I.e remove 25, 27, 29 etc...etc.  Can someone please help?  Thanks!
Steve EckermanSystems AdministratorAsked:
Who is Participating?
 
SteveConnect With a Mentor Commented:
DELETE YOURTABLE.YOURFIELDNAME
FROM YOURTABLE
WHERE (((YOURTABLE.YOURFIELDNAME) = 27));
0
 
SteveConnect With a Mentor Commented:
DELETE YOURTABLE.YOURFIELDNAME
FROM YOURTABLE
WHERE (((YOURTABLE.YOURFIELDNAME) In (25,27,29)));
0
 
awking00Commented:
Are you saying, for example, that you have a record with a period of 25 and other records that also contain a period of 25 and you wish to remove the duplicates (i.e. all but one record with a period of 25)?
0
 
Steve EckermanSystems AdministratorAuthor Commented:
No I have two different records in the period field one is 25 and the other is 27 the rest of the data in the table is a duplicate except for the 25 and 27.  I would like to remove all of the 27 records.
0
 
Steve EckermanSystems AdministratorAuthor Commented:
Great answers!  Thanks!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.