Calculation Problem

[access_Newbie1]

I'm a new user to Access so thank you in advance for being patient.....I am
creating a form to store hours worked monthly. In that form is a subform with
a layout that looks like this....

ID/JobNumber/Jan/Feb/Mar/Apr/May/June/July/Aug/Sep/Oct/Nov/Dec

Underneath each month is the hours that were worked (ex: 32.00). I need to
add all of those months to get one grand total for each JobNumber. And then I
want to create another formula for the main form that shows the total hours
also. I have tried various formulas but I can't seem to figure it out!I hope
that makes sense! Thanks!!

 

[ruralguy via AccessMonster.com]

It looks like you are thinking about the problem like a spreadsheet. Each
Month should be another record so the Months will be vertical rather than
horizontal. Once you change your table design then the summing becomes
trivial.