Remove duplicate records?

Hi all,

I have imported a table which has several thousand records but in the first
column, there are always going to be duplicate entries but the info in other
columns may be different. Is there a way I can specify that say, "if data
is equal to above cell, do not show".

I used to do this in Excel and had written a macro which would effectively
run the above condition, put "Yes" in another column then filter only
showing "No" results. It's just too big for Excel now unfortunately.

Any help much appreciated

TAI

Jackmac

Jackmac,

Start making a new query in design view, add the table, select all the
fields you want to display and then go to menu View Totals and notice the
new line that appears in the grid, headed Total:. Leave the setting to the
default Groub by under your first field, and change it to First under every
other.

You could even chnge the query from palin Select to Make Table (Query Make
Table) and store the "filtered" records in a new, smaller table to work
with.

HTH,
Nikos

"Jackmac" wrote in message
...
Hi all,

I have imported a table which has several thousand records but in the
first
column, there are always going to be duplicate entries but the info in
other
columns may be different. Is there a way I can specify that say, "if data
is equal to above cell, do not show".

I used to do this in Excel and had written a macro which would effectively
run the above condition, put "Yes" in another column then filter only
showing "No" results. It's just too big for Excel now unfortunately.

Any help much appreciated

TAI

Jackmac