Recent content by sys_daw

Ok, thanks to you all for your help, I will revisit the design and see if the cross-tab query works.

If a customer buys 2 products this year and bought 15 last year how would I handle the M1_Units etc for those 13 products that have not been purchased this year if the data were all in one table?

Thanks for the advice ScooterBug and the union query however the problem is still there. The result needs to be that each customer (only Oscar in this case) needs to appear on one row therefore showing a sum of M1_Units, M2_Units etc and the sum of the total current year but without showing...

I have two tables, one that contains sales data for the current year and the other contains sales data for the previous year. The data in both tables relate to one customer. What I want to do is show the total values for both the current year and previous year on the same row. In the attached...