Will not recognize date field

  • Thread starter Thread starter Sharon
  • Start date Start date
S

Sharon

The code wants to put "Approval" in every record whether
the [mgr_date] has data in it or not. The [mgr_date] is
formatted as a data field.

I've used --not null --, = not null. Is there some other
query I need to use with a date field?

While Not
NoExceptionDataBase.Form_NoException.Recordset.EOF
Select Case ExcptRate
Case Is = 0
[NoExcptTot] = "=0%"
Case 0.099 To 0.1
[NoExcptTot] = "> 0% and =< 10%"
Case 0.11 To 0.25
[NoExcptTot] = "> 10% and =< 25%"
Case Else
[NoExcptTot] = "> 25%"
End Select
If [mgr_date] = Not Null Then
[Approval] = "Approved"
Else
[Approval] = "Not Approved"
End If
 
Try using:

If Not IsNull([mgr_date]) Then

There's quite a few Is Functions that you can use for whatever type you are
checking for.
 
Back
Top