hi there.
I am having issue using the "=sum()" function for reports
it is giving me #error on the report form.. I am using the following
unitPrice=number
qty=number
I query them and have another column, Amount: [unitprice]*[qty]
on the report form, i have another control named Total, which is not formatted, i set its control source as =Sum([Amount])
When I run the report, the total just displays "#Error"