Duplicate records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Martin - 27 Feb 2004 22:08 GMT

Hello, I currently import a text file into my database as
a table "tblMain" what I have in this table are the
following fields; "ID" "LastName" "FirstName" "Absences"
and "Date". The problem I am having is that I have the
names of employees who have been absent more than one time
show up in multiple records, unfortunately this text file
gets emailed to me on a monthly basis. Is there a way I
can eliminate these duplicate records and streamline it
into a table where I only see one record per person but I
see how many absences they have and on what dates they
were absent?

Your help is appreciated,
Martin

Reply to this Message

Jeff Boyce - 28 Feb 2004 12:59 GMT

Martin

If your import file contains "Absences" (plural, so I assume this is a
number), and "Date" (I assume this is a single date), I don't see how you
could end up with what you asked for, "how many absences they have and on
what dates they were absent".

You didn't indicate if the "ID" field is unique to the source system, or is
a unique ID for the individual. That is, could "Smith, John" get imported,
over time, with more than one ID?

You are using a field named "Date" -- this is a reserved word in Access, and
will cause both you and Access to have severe headaches trying to figure out
whether you are referring to the Date() function or ...?

More info, please...

Signature

Good luck

Jeff Boyce
<Access MVP

Reply to this Message