Table has field with duplicate records

[Allison]

With your help!!! I've designed my first Make Table Query
and there is a field within my Table that has duplicate
records. The duplication appears accross fields. I tried
to append, but for some reason that did not work. I also
tried to change the index to Yes(no duplicates) for that
particular field but I assume since it's not the primary
key this will not work. (I also received an error
message). Is there a way to get rid of the duplicate
records within my Make Table Query or in the actual table.
I was thinking maybe there is some criteria that I could
put in before I run the query.

I need a step by step example of how to accomplish this
task!!! Again Thanks for all of your help and support!!!

 

[Bas Cost Budde]

With your help!!! I've designed my first Make Table Query
and there is a field within my Table that has duplicate
records.

Is that the same as duplicate values?

The duplication appears accross fields. I tried
to append, but for some reason that did not work.

Could you state how not? That is, could you not start the append, or was
there an error? What message?

I also
tried to change the index to Yes(no duplicates) for that
particular field but I assume since it's not the primary
key this will not work.

Not necessarily. But if a table contains data already, and you change
the index to Unique, you may get complaints that the data in that field
is not unique. You cannot create a unique index then, I find that
reasonable.

Is there a way to get rid of the duplicate
records within my Make Table Query or in the actual table.

you can create a query on your table that uses GROUP BY (a Totals query)
or set in the Properties the setting 'unique values' on.

 

[John Vinson]

With your help!!! I've designed my first Make Table Query
and there is a field within my Table that has duplicate
records. The duplication appears accross fields. I tried
to append, but for some reason that did not work. I also
tried to change the index to Yes(no duplicates) for that
particular field but I assume since it's not the primary
key this will not work. (I also received an error
message). Is there a way to get rid of the duplicate
records within my Make Table Query or in the actual table.
I was thinking maybe there is some criteria that I could
put in before I run the query.

I need a step by step example of how to accomplish this
task!!! Again Thanks for all of your help and support!!!

What I'd suggest is that you delete the table containing the dups,
recreate the table, empty, with the No Duplicates index on this field,
and *then* run your query as an Append query instead of a MakeTable.

Alternatively, set the Unique Values property of the MakeTable query
to TRUE before you try to run it.

It won't let you create the no duplicates index because there *are*
duplicates. Creating an index won't delete records for you; it will
just pop this error.