Largest Numbers...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
That should be 30 fields not columns :-)

Your problem is the table design. You designed it like a spreadsheet
not a database table. Each record (event) needs to be a record. Right now,
if it were my data, I would export it to Excel and work with it there.

However in access you should be able to create a report totaling those
fields and I understand you can also do it in a query, but I have not tried
it myself.
 
Brendan said:
I think you probably meant rows or records, Joe?
Click to expand...

In the final corrected product, records, yes. However it appears the OP
has thirty fields.
 
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...
 
Alex said:
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...
Click to expand...

I believe you could turn it around in Excel. Of course I am no Excel
expert, that's my girlfriends job, I do Access she does Excel. :-)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

News Largest data breach revealed - 773m email addresses and 21m passwords published 12
"Rolling" quarterly average 3
Excel Getting an annualized figure based on YTD in Excel 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Data Relationship Puzzle 3
Finding Next Largest Number Based on Criteria 3
Appending new columns from one table into a static table 5
Largest recorded data breach 7

Back
Top