Hi,
I rarely use Access and have imported a file that I need to condense. It is for payroll purposes and has multiple fields but the 3 I am focused on are:
Employee
Paytype
Pay
I want to Sum up the Pay of all lines where Employee and Paytype combination are similar.
The data I have now have multiple lines where the Employee field and Paytype field are similar and I want to combine them into one row.
Thanks!