Summing Fields????

[Dawny]

I am new to access and therefore this may be a very simple problem that I havent got a clue how to get around!!

I have created a query which has over 250 fields, all of which need summing. Is there a quick way of being able to sum all of these fields without me having to go through and sum each field individially????

If anyone can help me with this I would be mst grateful.

Thanks in advance

Dawn

 

[Andrew Fergus]

Hello Dawn and welcome to Mr Excel.

When you say there are 250 fields are you referring to the columns in the query? If so, then you might need to look at normalising your database because unfortunately you can't use columns of data in Access as easily as you can in Excel. There are some articles from Microsoft here and here that might help with setting up the database efficiently.

If the 250 fields refers to rows in your query, then there is an article from MS here that explains how to do that.

HTH, Andrew.

 

[Dawny]

Hi Andrew,

Thank you for your reply. I am wanting to sum records in a query which one of the links you provided does describe. However whilst I have worked out how you sum each field individually i.e. totals, change to sum, given the fact I have 250 fields which need changing I wondered whether there was a quicker way of doing them all at once rather than clicking through and changing them all individually.

Any ideas???

Thanks again.

Dawny

 

[Dawny]

Hi Andrew,

Thank you for your reply. I am wanting to sum records in a query which one of the links you provided does describe. However whilst I have worked out how you sum each field individually i.e. totals, change to sum, given the fact I have 250 fields which need changing I wondered whether there was a quicker way of doing them all at once rather than clicking through and changing them all individually.

Any ideas???

Thanks again.

Dawny

 

[Andrew Fergus]

Hi Dawn

I'm not familiar with a quicker way but when I am presented with such a daunting repetitive task, I do this : save my work regularly, click the first field, put away my mouse and then I alternate tapping the "Tab" and "S" keys as fast as I possibly can (a bit like playing "chopsticks" on the piano <- you don't want to hear it ).

Andrew

 

[Dawny]

You are an absolute star Andrew!

Using the tab and s keys are much quicker than individually clicking through each field.

Thank you very much

Dawny