>Good day everyone,
>I need some help with the syntax for a report please.
>The end of my report has a few calculated fields of the sum of each field of the report. I would like to then sum those fields together for a grand total on the same end page but I am unsure as to how I need to go about it.
>I get an "Syntax Error" when I try the following code as the expression for field on the report:
>SUM(table.field1,table.field2,table.field3)
>I have the "Calculate field" set to SUM at "End of Report".
>
>Thank you!
>Max
Max,
I would suggest adding a report variable that adds the fields together. Set the Initial Value to 0 and the Value to Store as teh summation of the three fields. Then select the Sum radio button. Set the Reset to the End of the Report and you can then add a field to display the variable anywhere in the report.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao