adding fields in a query...

  • Thread starter Thread starter needsomehelppls
  • Start date Start date
N

needsomehelppls

Hi,

I´m creating a query and am trying to sum up the values for the
different fields (value in column a, column b, column c..etc, for the
same row) and simply can´t. I´ve trying to use the DSum but it doesn´t
work...do you know how to input the appropriate formula? thanks a lot!
 
Hi,

I´m creating a query and am trying to sum up the values for the
different fields (value in column a, column b, column c..etc, for the
same row) and simply can´t. I´ve trying to use the DSum but it doesn´t
work...do you know how to input the appropriate formula? thanks a lot!
Click to expand...

Sum (and Dsum) work by summing a SINGLE field from MANY rows of a
table (going "down"). If you want to sum across, which by the way
suggests that you may not have a properly normalized table design, you
cannot use a function to do it; instead, simply create an expression
in a vacant Field cell:

SumAcross: [A] + + [C] + ...

If any of the fields are empty the sum will be NULL; to avoid this use
the NZ() - Null to Zero - function:

SumAcross: NZ([A]) + NZ() + NZ([C]) + ...
 
Back
Top