Trouble with Summing over Group

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2003. I have a report that has a control in the group footer whose
control source is defined as:

=Sum([PLEDGED])

PLEDGED is in the underlying query (the reports record source) and is
defined as:

PLEDGED: FormatCurrency(DSum("[AmountOwed]","Sponsors Mailing
Query","[GolferID]="+Str([GolferID])))

When the report tries to calculate Sum([PLEDGED]) I get the following error:

This expression is typed incorrectly or is too complex to evaluate. For
example, a numeric expression may contain too many complicated elements. Try
simplifying the expression by assigning parts of the expression to variables.

WHAT CAN I DO TO REMEDY THIS? THANKS.
 
Chaplain said:
Access 2003. I have a report that has a control in the group footer whose
control source is defined as:

=Sum([PLEDGED])

PLEDGED is in the underlying query (the reports record source) and is
defined as:

PLEDGED: FormatCurrency(DSum("[AmountOwed]","Sponsors Mailing
Query","[GolferID]="+Str([GolferID])))

When the report tries to calculate Sum([PLEDGED]) I get the following error:

This expression is typed incorrectly or is too complex to evaluate. For
example, a numeric expression may contain too many complicated elements. Try
simplifying the expression by assigning parts of the expression to variables.
Click to expand...


The format function converts the value to text. You can't
sum text strings. Get rid of the Format function.
 
Back
Top