I've been using access for a while but in a very passive environment. My first post is a question, I need some help on this.
Why doesn't this statement compare correctly?
If Rst.Fields("DuesPaidYear") >= Val(Format(Now(), "YY")) Then
GoTo Checktime
End If
The table column is a numeric 2 digit field. When the table field is 10 and the year is 14 it does not show as low.
Thanks for any help.