I have this querty:
Then I am trying to total it in the form footer and it is giving me an #Error.
For example here is one of the total formulas:
=Sum(Nz([TotalAmountOnInvoice],0))
What am I doing wrong? These totals work when I load a different query with the same field names. This is a summary query and the other query is a detailed query, so my users can switch between the two.
Code:
SELECT tblWillCallLog.ReceivedDate, Sum(Nz([Payment])) AS TotalPayment,
Sum(Nz([AmountOnInvoice])) AS TotalAmountOnInvoice,
Sum(Nz([AmountOnInvoice])-Nz([Payment])) AS TotalOutstanding, Month([ReceivedDate]) AS MonthRange
FROM tblWillCallLog LEFT JOIN tblCustomers ON tblWillCallLog.CustNum = tblCustomers.CustNumber
GROUP BY tblWillCallLog.ReceivedDate, Month([ReceivedDate])
HAVING (((Month([ReceivedDate]))=Month(GetDateOfRecord())))
ORDER BY tblWillCallLog.ReceivedDate;
For example here is one of the total formulas:
=Sum(Nz([TotalAmountOnInvoice],0))
What am I doing wrong? These totals work when I load a different query with the same field names. This is a summary query and the other query is a detailed query, so my users can switch between the two.