I am using a query to gather data for a report.
i have a caluated field as below.
i would like set up another field within that query to give me a total of the result LineTotal.
i have tried =sum[LineToatal]
I understand that this is best done in the query before its goes to the report.
Thanks for looking at this