Adding the values from 3 Text Boxes

[crimedog]

I have [TxtMo1] [TxtMo2] [TxtMo3] in the Details section of my report - They are unbound with a Row Source that uses Dlookup - the text Boxes are formatted as Currency [TxtMo1] [TxtMo2] [TxtMo3] all display the correct amount (in this case $25,000
In the <edit> Report <edit>Footer have An unbound Text Box formatted as Currency. In the control source I have =[TxtMo1]+[TxtMo2]+[TxtMo3] it should = $75,000

I get error #Type

It feels like this should be simple. Any help would be appreciated



** I had it in the page footer - but moved it to Report Footer = same problem

[crimedog]

never mind moving it from Page footer to report footer fixed it. I have another issue - I will start a new thread

[June7]

Do you mean ControlSource instead of RowSource?

Calcs in header/footer section are normally to aggregate data (Sum, Avg).

Aggregate calcs cannot reference controls, they must reference fields from the RecordSource.

Can just do the addition calc in the Detail section.

[crimedog]

Ok - the printed version shows the amount I want (so I thought it was fixed) but the Report view still shows #Type
I am getting an error when I try to sum the fields from a Query (also in the Footer) Sum([Qry1]![Revenue]) = #Error

[crimedog]

moved it into details and the Additions are working right - but the Sum([Qry1]![Revenue]) is still showing Error

[June7]

Revenue is a field in the report RecordSource?

Probably don't need the [Qry1] prefix.

[crimedog]

The Main report does not have a recordsource - the subreports each have a recordsource : Qry1 Qry2 Qry 3
If I total on the subreport - and there are no records it won't show. So I put the textbox into the report details

[June7]

Why subreports - what is the data in each?

If you need to reference subreport textbox from main form, set the subreport container name different from the object it holds, like: ctrQ1

Then try:

=Nz([ctrQ1].Form.textboxname,0) + Nz([ctrQ2].Form.textboxname,0) + Nz([ctrQ3].Form.textboxname,0)