I currently have an Access query that audits a change log from our mainframe system. I've created a table that lists department numbers in a row and a corresponding payment in other columns labeled week 1 through week 10. What I need to do is show where the dollar amount changes based on the department number.
So if someone was in dept 3 and they paid 30.00 in week 4 but then in week 10 they paid 40.00. I want to show that change.