summing query tutorials?

  • Thread starter Thread starter test guy
  • Start date Start date
T

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