Calculation Problem

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

Guest

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!!
 
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.
 
Back
Top