totaling dsum controls

  • Thread starter Thread starter binny
  • Start date Start date
B

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
 
Use the NZ function like this ---
Nz(DSum(xyz,fre,fty), 0) + Nz(DSum(abc,def,jkl), 0)
 
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
Click to expand...

Set the control source of control C to

=NZ([A], 0) + NZ(, 0)
 
thanks guys you could read the help files for a month and still not work some
of this stuff out by your self.
--
binny


John W. Vinson said:
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
Click to expand...

Set the control source of control C to

=NZ([A], 0) + NZ(, 0)
Click to expand...
 
Back
Top