Hello,
I have a report fetching from a query in which one of the fields is aggregated, SumofOrderQty
In my report I wanted to perform a simple calculation on this field like =[SumofOrderQty]/1000 but it returns a type error so apparently Access can't perform a calculation on a calculation, what would be the work around?
Thank you