Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Deleting duplicates and unmatched records

Resolved · Low Priority · Version 2007

Reply Mon 18 Jul 2011, 16:09Delegate Sarah said...

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?

For upcoming training course dates see: Pricing & availability

Reply Tue 19 Jul 2011, 15:24Trainer Simon said...

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

Reply Mon 15 Aug 2011, 14:33Delegate Sarah said...

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.

Access articles

· Microsoft Access Cheat Sheet: Tips and Shortcuts
· So You Want To Create Forms In Access 2007?
· Microsoft Access Training Opens Doors
· How To Use Lookups For Data Entry In Microsoft Access
· Cheating With Access Templates

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

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips