adp report sum()

[Charlie]

Access 2003 ADP Project

In my Access Report, I cannot use any aggregate functions, sum, avg in the
control source of textboxes unless the control source is a field from the
stored procedure linked to the form,

example, in the group footer I need this:
=Sum( [txt_Detail_Total] )
in the detail, '[txt_Detail_Total] ' exists and is simply quantity * price

I get Error messages like
"Column ???? does not exist in appropriate rowset"
or
"Aggregate Functions are only allowed on on output fields of the
recordsource"

 

[Guest]

you can still refer to form variables, but it can be a lil bit tricky
sometime.

i usally make functions in VBA to lookup most of the important equations

 

[Charlie]

I though [txt_Detail_Total] was a form variable, can you post an example ?

you can still refer to form variables, but it can be a lil bit tricky
sometime.

i usally make functions in VBA to lookup most of the important equations

Access 2003 ADP Project

In my Access Report, I cannot use any aggregate functions, sum, avg in the
control source of textboxes unless the control source is a field from the
stored procedure linked to the form,

example, in the group footer I need this:
=Sum( [txt_Detail_Total] )
in the detail, '[txt_Detail_Total] ' exists and is simply quantity * price

I get Error messages like
"Column ???? does not exist in appropriate rowset"
or
"Aggregate Functions are only allowed on on output fields of the
recordsource"

 

[Guest]

you make a function called fnFirstName

Public Function fnFirstName
fnFirstName = forms!frmHappy.txtFirstName
End function

I've found that this allows me to get around a lot of sore spots in ADP.

-hth

aaron

I though [txt_Detail_Total] was a form variable, can you post an example ?

you can still refer to form variables, but it can be a lil bit tricky
sometime.

i usally make functions in VBA to lookup most of the important equations

Access 2003 ADP Project

In my Access Report, I cannot use any aggregate functions, sum, avg in the
control source of textboxes unless the control source is a field from the
stored procedure linked to the form,

example, in the group footer I need this:
=Sum( [txt_Detail_Total] )
in the detail, '[txt_Detail_Total] ' exists and is simply quantity * price

I get Error messages like
"Column ???? does not exist in appropriate rowset"
or
"Aggregate Functions are only allowed on on output fields of the
recordsource"