Steve Eckerman
asked on
Deleting Duplicate Records In An Access 2003 Table.
Attached is a Access 2003 PartForecast2015.xlstable where I have duplicate records for Fiscal Year 2015. I want to remove all of the duplicate records for 2015. Can someone please assist? Thanks!
ASKER
For Fiscal Year 2015 PSINO AIR107 has one record where all of the fields have a value and then there is another PSINO AIR107 record where the MGR field is null, then Annual Volume is null and all of the months are null. So basically I need a SQL statement that will remove all Fiscal Year 2015 records where the PSINO is a duplicate and the MGR, Annual Volume and Months of the year fields are null.
ASKER
Did that help Jeff?
Ok, so not a "true" duplicate record...
Then it looks like it would be easier to delete all record where the Manager, Annual Income, and all the months is/are empty...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Triple check the results to see if all the records needing to be deleted, were deleted.
Also make sure no records remain that perhaps should have been deleted (due to missing any other criteria)
Also make sure no records remain that perhaps should have been deleted (due to missing any other criteria)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try Dale's solution first....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
They worked like a champ. You guy's are true SQL gurus!!! Thanks!!!
Can you clearly identify, for us, a sample record and its duplicate?
This will save us from scanning each of your records there manually...
JeffCoachman