I have a relatively simple sets of tables for Expenses and Payments and about a dozen transactions are displaying as outstanding amounts in a query although the amount displayed is zero.
The fields concerned are as follows:
Total value of an expense.
Code:
Total: [AMOUNT]+[TAX]
Total value of Paid To Date for the expense.
Code:
PTD: IIf([Q: Expense Payments (summary)].[Sum Of Amount]<>0,[Q: Expense Payments (summary)].[Sum Of Amount],0)
Calculated Due Out value.
Code:
Due Out: [Total]-[PTD]
So, although it's only a handful of records out of several thousand, this is what is happening:
ID-14115
Total [48.15]+[3.37]=51.52 (verified)
PTD=51.52 (verified)
Due Out=0.00
So although the field is displaying a zero value when the field is selected, the actual value shows as '-7.105427357601E-15'. '-7.105427357601E-15' is actually always the value in the fields that show zero value for the handful of records.