Sarah has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Deleting duplicates and unmatched records
If you run a duplicated records query and multiple records are found, if you then run an unmatched records query and also find multiple records, how can you automate deleting the appropriate records instead of doing it manually?
RE: Deleting duplicates and unmatched records
Hi Sarah,
Thank you for your question and I hope you enjoyed the course.
I have tried three different things today and still no luck. I will keep looking today and on the plane tomorrow and try and figure something out for you.
Please bear with me.
Regards
Simon
RE: Deleting duplicates and unmatched records
Hi Simon,
Thanks for this - apologies for the delay in responding but I've been on holiday and am only just catching uo on emails.
I am still interested in a solution to this problem if possible.
Also, on the advanced course you showed us pivot tables in Excel and were going to give us some information on these. Is it possible to email me anything?
Thanks
Sarah
