Hi all, this is my first post and I want to reconstruct one table in access but not sure how to do it,
My current Table look like
Customer Sales Month
A 1 190001
B 1 190001
A 2 190002
B 2 190002
Because the sales data is accumulated (reset every January), I want to recreate with monthly sales...