H
HubbyMax
I have a report that I am having trouble with. The report is controled by
a query. In the query I have a calculation.
AVG((([OUnitPrice]+[NUnitPrice])/2)*[QuantityIssued]]) AS AVGCOST
I use this calculation to fill a order cost of an item on the report. I
then have a text box on the report with the calculation, =SUM([AVGCOST])
to show the total cost.
The problem is that if you manually add all the results for the query
calculations the total is 423.25. When the calculation is done by the
report itself it totals 423.24. Any ideas why this happens? It does not
happen for all calculations on the report, most are equal with a manual
addition.
a query. In the query I have a calculation.
AVG((([OUnitPrice]+[NUnitPrice])/2)*[QuantityIssued]]) AS AVGCOST
I use this calculation to fill a order cost of an item on the report. I
then have a text box on the report with the calculation, =SUM([AVGCOST])
to show the total cost.
The problem is that if you manually add all the results for the query
calculations the total is 423.25. When the calculation is done by the
report itself it totals 423.24. Any ideas why this happens? It does not
happen for all calculations on the report, most are equal with a manual
addition.