DMax doesn't seem to recognize the use of "LIKE" in the criteria expression. Is it not supported in such context?
Code:varLastPayID = DMax("TRecID", "QRegister", "Description = 'LIKE Verizon*'")
DMax doesn't seem to recognize the use of "LIKE" in the criteria expression. Is it not supported in such context?
Code:varLastPayID = DMax("TRecID", "QRegister", "Description = 'LIKE Verizon*'")
try
"Description LIKE 'Verizon*'"
Thanks Ajax, that worked perfectly.
Bill