summing query tutorials?

[test guy]

I need to write a query that will sum a number of fields, so that I can use
it in a report. Is there a decent tutorial somewhere that can help educate
me in this aspect? Thanks-

 

[Michel Walsh]

Hi,


Base the report in a query. In the query, make a computed expression like:

Nz(field1, 0) + Nz(field2, 0) + ...

To make a sum, vertically, it is much easier, just a

SUM( fieldName )




Hoping it may help,
Vanderghast, Access MVP