Add two similar records with a query

[lipin]

How can I add very similar records so I have only one per employee? If they have more that one incident in a day, there are two records for that day. I would like to combine these into 1 record for the day like this:
field: data:
EmplID 7020
Date 9/9/02
TOPP
NS
MT 3.5

EmplID 7020
Date 9/9/02
TOPP
NS 5
MT

But instead of these two records I would like the table to only have 1 for Employee 7020 on 9/9/02 that has the 3.5 in MT field and the 5 in the NS field.

EmplID 7020
Date 9/9/02
TOPP
NS 5
MT 3.5

I can find Duplicates with query but how do I combine the two?
THANKS.

 

[Cosmos75]

I am confused, are all the fields (EmplID, Date, TOPP, NS and MT) in one table?

If so,
You can just go back the record with this data
EmplID 7020
Date 9/9/02
TOPP
NS
MT 3.5
and edit the record to have
NS 5

 

[NOL]

Try this ?

select EmplID,Date, TOPP, Sum(NS), sum(MT)
from YourTable
group by EmpID,Date, TOPP;