Microsoft Access Dcount -- check if field has a valid date
Hi.
I would appreciate it if someone helped me with the correct syntax for this "Dcount" example.
[Import Success] is a date field
I would appreciate it if someone helped me with the correct syntax for this "Dcount" example.
[Import Success] is a date field
Dim RecCount As Long:
RecCount = DCount("[StockNum]", "tbl StockItems", IsDate([Import Success]) = True)ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank You
ASKER
Thank You.
ASKER