I am using Dcount to look if a field (CL - String) in a table has a particular date of another field (DiscoDiag - Date) in MS Access 2003.
I'm testing with the following VBA line but getting an error. I believe its just my syntax or placement of quotes. I want to put up a message when the date of DiscoDiag is after todays date. Any help is appreciated.
If DCount("*", "tCl", "CL = """ & sFindODBrand & """ And DiscoDiag < Now()""") > 0 Then MsgBox "BAM!"