## Calculating a sum whem some of the data is negative

## Calculating a sum whem some of the data is negative

(OP)

I have a field in a subform labeled [Loss/Gain]. I need to put the sum on the main form. The numbers can be either positive or negative. I am using "Sum([Loss/Gain]) in the field. I know from reading other sources that summing on a calculated field may be a problem as well as negative numbers. Is there a work around I can use. Thanks very much.

Bill

Bill

## RE: Calculating a sum whem some of the data is negative

you dont need to know the lable name or caption but the text box name

and use this on the main form =sum(forms!formname!subfromControlName!Textboxname)

## RE: Calculating a sum whem some of the data is negative

## RE: Calculating a sum whem some of the data is negative

Name:txtMySum

Control Source: =Sum([Your Field Name Here])

Then in the main form, add a text box:

Control Source:=[Your Subform Control Name].[Form].[txtMySum]

DuaneHook'D on Access

MS Access MVP

## RE: Calculating a sum whem some of the data is negative