counting each item used on a job and totalling each across records

[dunnjt]

My brain must be becoming petrified from too much Access. I just can’t get my head around what should be an absolutely super-simple program.
A table called “Material” underlies the form where the user can enter/edit the materials and the quantity of each material used on a specific job(plumbing job).There are 26 items on the list of possible materials to be used)
For example, the user could enter items and quantities used on a particular job, each job having it’s own list of materials -
Tee,Blk,1” 10
Tee,Blk,2” 15
Coupling,Blk,90 1” 5
Coupling,Blk,90 2” 15
Nipple,Blk 1” 8
Nipple,Blk 3” 15

My table and form work fine but I need some “sums” and it eludes me how this can be done. For each record(the list or materials for each job} I need a simple count of the items used on each job such as “68” in the example above.
I also need a total for each item used on all jobs but this does not present a problem.
Overdosing on Access, is that possible? I’ve been developing Access applications since the early ‘90s and have always been able to arrive at workable solutions to problems as they presented themselves. I can’t believe that I can’t make this happen. Duh!
Could some one please make a suggestion on how to get the total items used on a job? Thank You, I feel like a genuine “newbie”. No code please - I am clueless and codeless.
Thank you,
Jerry D.

 

[MoiraT]

I symapthise with ODing on Access - happens all the time for me!
This might work for a total number of items on your form. In the form footer create an unbound control with the control source as:
=Sum([YourControlName])

Where YourControlName is the control on your form that shows the number of each materials on the job
HTH