Remove duplicate records?

  • Thread starter Thread starter Jackmac
  • Start date Start date
J

Jackmac

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
 
Back
Top