Deleting duplicates

Resolved · Medium Priority · Version 2013

Tue 26 Apr 2016, 10:28 Delegate Claire said...

Claire has attended:
Access Intermediate course

Deleting duplicates

Following on from the Intermediate course last week, I am trying to use the method that was used to remove duplicates - by selecting several fields that need to be unique as primary keys and then I would create an append query using a blank copy of my table structure alone. I am selecting several fields as the primary key but I am getting an error message saying that "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data..., remove the index or redefine the index to permit duplicate entries and try again." I have some test data which includes duplicates so I am trying to see if it will remove them but not being able to get that far.
Thanks,
Claire

Tue 26 Apr 2016, 12:41 Trainer Doug said...

RE: Deleting duplicates

Hi Claire

I've just tried out the process of removing duplicates you and the trainer suggested. It gave a different warning but then removed the duplicates in the appended table.

Hard to tell why it didn't work on your test data. It might help if you send your example to info@stl-training.co.uk and ask to forward to Doug.

Another way to remove duplicate records from a table is to create a normal select query (rather than append query).
Add all the fields and set the query property Unique Values to Yes. (To see Query properties, right click, the background of a query and choose Properties).

The query could then be changed to a Make Table query to create the table of unique records.

It would be worth trying this to find out how many unique records there are.

Hope that helps?

Regards
Doug Dunn
Best STL

Fri 20 May 2016, 14:13 Trainer Doug said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Fri 27 May 2016: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.