Make Table Query

[JJT]

Hello. I have a table in which some of the records have the same info in the "Name" field. Is it possible to create a Make Table Query that will not select any records with duplicate info in the "Name" field?

 

[dcx693]

Are you saying that you only want to insert records that have a unique entry in the "Name" field? So if any two records have the same entry in that field, they both do not get inserted?

You can do this with a totals query with a count on the Name field. Just specify the criteria as: 1, for example.

 

[JJT]

Yes. I did not get your example.

 

[dcx693]

OK, I'll try to elaborate. A make table query is an action query. An action query is basically a special type of "select" query that performs an action based on a record selection.

A totals query is a type of "select" query. It allows you to aggregate records together, so you can group and total them. Let's say you've got 10 different teams and you've got 100 records of detail. If you wanted to get totals by team, you'd group on the team names and sum or count the other fields. That's what a totals query does.

What I'm proposing is that you run a totals query where you ask Access to show you only those records where the count of the Name field =1. That way, you'll only get records that have one instance of a particular name.

Once you have that totals query running, go to the Query menu and change it to a make-table query and proceed on.