×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

I have a table with multiple record

I have a table with multiple record

I have a table with multiple record

(OP)
I have a table with multiple records in it. I have a find duplicates query to find the duplicate records. The duplicate query counts the instances, but I need a way to bring up each individual record. I have another query with both the original table and the duplicates query in it with a relationship in order to pull the individual duplicated records. However it won't let me either update the record or delete the record. This can't be that difficult but I haven't written much in Access lately and my skills are a bit rusty. Any help/advice would be greatly appreciated.

RE: I have a table with multiple record

A find duplicates query typically won't allow edits. You might be able to accomplish something similar using DCount(). If you need more information, please provide information about your table as well as the SQL view of your find duplicates query.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

RE: I have a table with multiple record

(OP)
Thank you for your reply. I have solved it by creating a temp table with the results from the find duplicate query, changing that query into an append for that table and changing out the find duplicate query for the temp table inside my query that shows each record. Now I can delete the record from the main table with no problem.

RE: I have a table with multiple record

Sounds like a lot of work but if it works for you then go for it.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close