Totalling Expr1 in a report

[SJL]

Hi
I am using a query to calculate saving amount in a report but want to show
total savings in Report footer. I cannot get total to appear using
Sum([Expr1]) is there some other expression I should use please?

Thanks

 

[Duane Hookom]

Why Expr1? Do yourself a favor and give your columns real names. It would
help to know the calculation that creates the column. I expect it might be
returning a string value rather than a number. When you view the datasheet
view is Expr1 left or right-aligned? If it is left aligned, you have create a
text/string expression which can't be summed or averaged.

If you provided the calculation, we could probably suggest a solution like
wrapping the expression in the Val() function to convert your calculation to
numeric.