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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Access Training and help » ms access training - Union Queries

ms access training - Union Queries

ResolvedVersion Standard

Tue 6 Mar 2007, 09:43 Delegate Navinder said...

Navinder has attended:
Access Intermediate course
Access Advanced course

Union Queries

How do I remove duplicates from a union query

Mon 12 Mar 2007, 10:00 Trainer David said...

RE: Union Queries

Hi Navinder

Sorry for the delay in getting back to you. I believe I have just answered this question in your second post. The URL for this answer is:
https://www.stl-training.co.uk/post-2113-duplicates.html #2113

I hope this answers your question
David

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

ms access training - Union Queries

Union Queries

RE: Union Queries

Access articles

Access tip:

Deleting duplicate records from a table