Hello guys
What is wrong with this code ?
Thank you very much in advanceintContractCount = Nz(DCount("PaymentID", "Payments", "PaymentDate= Between DateAdd('d',-60,Date()) And DateAdd('m',-2,Date())"), 0)
Expert
Windows 7 32bit 
Access 2010 32bit
Hello guys
What is wrong with this code ?
Thank you very much in advanceintContractCount = Nz(DCount("PaymentID", "Payments", "PaymentDate= Between DateAdd('d',-60,Date()) And DateAdd('m',-2,Date())"), 0)
Who is John Galt?
Windows XP Access 2007
Expert
Windows 7 32bit Access 2010 32bit
Show me this message
Who is John Galt?
Windows XP Access 2007
The comma shouldn't be there. Perhaps I should have said:
"Between" or "=" not both.
Expert
Windows 7 32bit Access 2010 32bit
Thank you my friend pbaldy
Who is John Galt?
Windows XP Access 2007
No problem, sorry for being unclear.
Error in code
VBA Code Returning Error Run Time Error 3061
Posting Permissions
Reply With Quote