Hi Folks
Could someone kindly help me with the syntax for the following?
AccLYJan = Nz(DSum("SumofAmount", "QryExpensesSumByMonthYear", "ExpMonth = 'Jan' And ExpType = 'Accounting'"), 0)
Both criteria are strings and I just cannot get it right!
Many thanks
Could someone kindly help me with the syntax for the following?
AccLYJan = Nz(DSum("SumofAmount", "QryExpensesSumByMonthYear", "ExpMonth = 'Jan' And ExpType = 'Accounting'"), 0)
Both criteria are strings and I just cannot get it right!
Many thanks