Largest Numbers...

A

Alex

I have a table with about 30 columns with most of them corresponding to a
Month over the past two years...
Each of these columns have list of how many items of a certaing type got
sold in that particular month, the item is managed by an ID number.

Now the problem is that I need to Add all the Items in all the columns which
corresponds to months, then compare those totals to see which one has the
largest number, that way I will be able to tell which month over the past two
years had the greatest number of sales...

Is there a way to this in Acess?? Thanks
 
A

Alex

yes... I actually have already done it in excel... :S just wondering if I can
do it automatically in access, and yes... thirty fields... I know of course
hot to total the fields in a query... I just dont know how to get the largest
number from those totals... you see...and if it is ineed "backwards" how
could I "turn it around" i.e. make the columns rows and vice versa...
 
Top