deleting duplicates and unmatche

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

Forum home » Delegate support and help forum » Microsoft Access Training and help » Deleting duplicates and unmatched records | Access forum

Deleting duplicates and unmatched records | Access forum

resolvedResolved · Low Priority · Version 2007

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

Mon 25 Jul 2011: Automatically marked as resolved.

 

Training courses

 

Recommend training98.7 %
recommend us
More live stats...

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

See also:
Hints and tips
Forum topics

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access articles

Please browse our web site to find out more about
access training courses and other training courses.

Access tip:

Create An Inaccessible Field On A Form

There is sometimes a need to make a field in a form look like a normal field but be completely inaccessible to the user. To do this:

In the Field's Properties
Set the ENABLED property to No
Set the LOCKED property to Yes

The field will not grey out, but the user will not be able to do anything with it.

View all Access hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.09 secs.