Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
Allen Browne has a solution here:
http://allenbrowne.com/subquery-01.html
duplicates within a table
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 25%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Mark Powell
0
Reputation points
i have a table that contains the following
CallDate
Customer
Callid
i seem to have a load of duplicates,i want to get rid of all the duplicates but leave one remaining. im a novice so is there a basic way to do this please or anyone who has the skills can give me a step by step example please
Microsoft 365 and Office | Access | For business | Windows
4 answers
Sort by: Newest
-
George Hepworth 23,120 Reputation points Volunteer Moderator2026-09-24T16:46:08.48+00:00 -
Deleted
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
1 deleted comment
Comments have been turned off. Learn more
-
Mark Powell 0 Reputation points
2026-09-24T16:40:49.57+00:00 looks like the records have been imported several times
theres hundreds to look at
-
George Hepworth 23,120 Reputation points Volunteer Moderator
2026-09-24T16:39:13.88+00:00 You can run the Query Wizard that find duplicates to get the full list of them. From there, deciding how to handle it would depend, in part, on how many you have. Fewer than a dozen might be just as quickly done by hand. Over a hundred would justify a full procedure.
Start with that Find Duplicates query and let us know what that reveals.
But I have a question about what a duplicate really is. Is it possible for a customer to call multiple times in the same day? Are those "duplicates" or not, by your requirement?