sum calculated fields

[qwertyjjj]

I have a detail form, which hs controls populated from a query.

For example,
Name Number
xxxx xxxx

This can be any length depending upon the amount of database records, so there might be 5 names, or 4 names, etc.

I then need to sum these in the footer. Is the possible?
I just seem to get #Error displayed when doing SUM([ControlBoxName])

 

[PHV]

In the footer section of a continuous form you may have a ControlSource like:
=Nz(Sum([field name]), 0)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[qwertyjjj]

Nope, it still somes back with #Error.

Is it possible to sum a field name in a Detail section of a form at ll?

 

[qwertyjjj]

Nope, it still somes back with #Error.

Is it possible to sum a field name in a Detail section of a form at all?

 

[randy700]

Exactly what code do you have in the textbox?

Randy