[AccessD] Wont Add Up

One of the fields may be null.  Anything + Null = Null.

Try this:

=Sum(nz([BODILY_INJ],0)+nz([CARG_DAMAG],0)+nz([CHRG_BAK],0)+
  nz([CLAIM_EXPS],0)+nz([PHYS_DAMAG],0)+nz([PROP_DAMAG],0)+
  nz([SALVAGE],0)+nz([SUBRO],0)+nz([WORK_COMP],0))

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Joe Hecht
Sent: Thursday, January 12, 2006 12:27 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Wont Add Up


txtPaidTotal Datasource  

 

=Sum([BODILY_INJ]+[CARG_DAMAG]+[CHRG_BAK]+[CLAIM_EXPS]+[PHYS
_DAMAG]+[PROP_DAMAG]+[SALVAGE]+[SUBRO]+[WORK_COMP])

 

If I view the subform only it returns $120,000 and change

 

If I view it on subform in a tab control values are showing
for the categories but the text box is null.

 

Any thoughts appreciated

 

 

Joe Hecht

jmhecht at earthlink.net