Search results for query: *

Thank you! I been starting out adding them like that without the sum and without the nz. Then moved on to things like count and sum and all. And when you told me about nz I kept going with sum and count and such. I can be so stupid at times. But I guess a month of working on something I have...

Yes. But now I made a new report/table/form for testing. It has: ID Field1 Field1 With the numbers I supplied above. On the form and report I have 4 text boxes: ID Field1 Field2 Total The Total textbox has the control source: =Sum(nz([Field1],0)+nz([Field2],0))

Right now a table. But I am sure I could make a query.

that still adds up the whole colomn. I want just the rows added. Like: 1 0 2 1 0 1 I want row one to equal 1.. but instead it is adding it up to be 3 1 0 Total: 1 2 1 Total: 3 0 1 Total: 1 I need those totals

I tried that =Sum(nz([PP1980]+[PP1981],0)) in a control source. but it adds up everything. i just want it to add for that row (for each person)

Ok, I have some expirence with VB and very little with Access. But I was drafted to help my co-worker work on this Access db. The problem I am having is: In a table we have cells filled with numbers. When we went to add this up for a total we kep getting errors. Not until we filled the blank...