It seems like this should be simple but I can't get it or find the answer. I have a report based on a query that displays dollar amounts from a table . The field name for the dollar amounts is amounts. I would like to total the dollar amounts at the bottom of the report. It seems like =sum([amount]) should work but I keep getting the "#error". Thank you for your help.