I am very new to Access. I am designing a database to help with government report that we must complete quarterly. I made a query and then designed a report based on that query. When we report to the government, they want the amounts for each transaction reported like this
(50,000.00 must be reported as 50). I have attached a screenshot.
In the query field I used this format FormatAmt: Format([Amt],"0,") however when I try to total this field on the report, the only options I have are to "count records" or "count values". What I need is for that column to total as numbers because there is an additional reporting requirement when a certain threshhold is reached. Sorry if this sounds stupid but I am realyy a nebie and this is my first stab at this.