duplicates within a table

Mark Powell 0 Reputation points
2026-09-24T16:32:38.2733333+00:00

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
0 comments

4 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. 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?

    Was this answer helpful?

    0 comments
  2. 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

    Was this answer helpful?

    0 comments
  3. 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

  4. George Hepworth 23,120 Reputation points Volunteer Moderator
    2026-09-24T16:46:08.48+00:00

    Allen Browne has a solution here:
    http://allenbrowne.com/subquery-01.html

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.