Trying to total query is giving me error (1 Viewer)

Djblois

Registered User.
Local time
Today, 11:54
Joined
Jan 26, 2009
Messages
598
I have this querty:


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;
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.
 

June7

AWF VIP
Local time
Today, 10:54
Joined
Mar 9, 2014
Messages
5,423
It should work. I cannot replicate issue. If you want to provide db for analysis, follow instructions at bottom of my post.
 

Users who are viewing this thread

Top Bottom