Hi;
I have the following code to give me the total amount spent and the total amount received for the current month and displayed in a textbox. It has started showing up as 0.00 all the time since January. I can't seem to figure out if I changed something or what I have done wrong
Here is my code if anyone can shed some light on this
Code:
=Nz(DSum("[Amount]","Expenses"," YEAR([InvoiceDate]) = " & Year(Date()) & " AND Month([InvoiceDate]) = " & Month(Date())),0)
=Nz(DSum("[AmountPaid]","PaymentsReceived"," YEAR([DateReceived]) = " & Year(Date()) & " AND Month([DateReceived]) = " & Month(Date())),0)
Thanks for any help you can give me.