Delete all but first

[CJ]

Hi Groupies

I have a table that keeps track of all of my employee transactions
(tblCampCosts). In one day the same employee may have many transactions that
are identical. I need to be able to retrieve just the first transaction. I
have tried using the Total function and changing Group By to First but the
resulting recordset is not updateable and I need it to be.

Is there some way to extract just the First occurrence and keep it
updateable?

 

[Allen Browne]

See:
http://allenbrowne.com/subquery-01.html#DeDuplicate

The article explains how to use a subquery to identify the 'first' record
for each person, and delete the others.

 

[CJ]

Hi Allen

Thanks for the insight and thanks for writing such an excellent article. It
actually
presents two options for me.