Morning,

I have a table that I need to de-duplicate. I need a de-duplicator that will look at the first two fields in a table, Employee No and week ending date. I would like the de-duplicator to check against the previous record to see if these two values are the same as the current record.

Does anyone have any idea's how I may approach this?

Regards,

Matt