Hi,
I am fairly new to access and am trying to create a report that pulls in the top 20 vendors descending by the sum of their expenses (shown) over 3 years.
The table has all the $ for all the vendors for every year.
I need something along the lines of:
2008 2009 2010 SUM
V1 15 15 14 '08-10
V2 13 15 14 '08-10
V3 12 13 13 '08-10
V4 10 10 7 '08-10
Please be very explicit with what I should do. Normally I use design mode... but simple copy paste SQL never hurts too!
Thanks!