P
Pat Dools
Hello,
I have a counter on my switchboard that runs with the following code:
Function MissingEntryCountRecords() As Long
Dim db As DAO.Database
Dim rst As DAO.Recordset
Set db = CurrentDb
Set rst = db.OpenRecordset("Select * From havecrf Where (formstat = 2 &
isnull(page) = False)")
rst.MoveLast
MissingEntryCountRecords = rst.RecordCount
End Function
If I leave at just 'formstat = 2', it works great, but I also need to check
if the field 'page' is null and I just can't seem to get the syntax correct.
Is it possible to get a second condition into the Where clause of
OpenRecordSet?
I have a counter on my switchboard that runs with the following code:
Function MissingEntryCountRecords() As Long
Dim db As DAO.Database
Dim rst As DAO.Recordset
Set db = CurrentDb
Set rst = db.OpenRecordset("Select * From havecrf Where (formstat = 2 &
isnull(page) = False)")
rst.MoveLast
MissingEntryCountRecords = rst.RecordCount
End Function
If I leave at just 'formstat = 2', it works great, but I also need to check
if the field 'page' is null and I just can't seem to get the syntax correct.
Is it possible to get a second condition into the Where clause of
OpenRecordSet?