[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