totaling dsum controls

[binny]

I have 2 calulated controls on a form with Dsums in them how do I add them
together when one is null
some times control A is null, some times contol B is null and some times
both controls have a value

I want to hide controls A & B just show a single total in contol C

 

[KARL DEWEY]

Use the NZ function like this ---
Nz(DSum(xyz,fre,fty), 0) + Nz(DSum(abc,def,jkl), 0)

 

[John W. Vinson]

I have 2 calulated controls on a form with Dsums in them how do I add them
together when one is null
some times control A is null, some times contol B is null and some times
both controls have a value

I want to hide controls A & B just show a single total in contol C

Set the control source of control C to

=NZ([A], 0) + NZ(, 0)

 

[binny]

thanks guys you could read the help files for a month and still not work some
of this stuff out by your self.
--
binny

I have 2 calulated controls on a form with Dsums in them how do I add them
together when one is null
some times control A is null, some times contol B is null and some times
both controls have a value

I want to hide controls A & B just show a single total in contol C

Set the control source of control C to

=NZ([A], 0) + NZ(, 0)