Duplicates delete

F

flow23

I have a large database, where most records are duplicated again and again.

Due to the large size... Is it possible to macro or other way.. where a new
table is created only with unique entries?

The table name is "data". fields are name, postcode, ID.
 
J

Jeff Boyce

Create a query with the fields you wish to preserve.

In query design mode, change the Unique Values property to "Yes". Confirm
that you only get one record ... (but if you are including an "ID" field,
I'm guessing that EVERY record is unique. You may want to rethink including
that field.)

Change the query to a make-table query. Run it.

You should now have a new table with one record/per.

(By the way, Access treats words like "name", and maybe "ID" and "Data" as
reserved words. You'll want to change these names of tables/fields in your
database, or risk confusion.)
 
F

flow23

thanks..
but where do I find the unique value property? I cant find it somehow?

I have access 03...
 
J

Jeff Boyce

Open the query in design mode. Click View, Properties (or right-click in
the gray space in the upper window and select Unique Properties).

Access HELP should also explain where to find Unique Properties.
 
Top