Help on a simple statement

[ynotaz]

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.

[ItsMe]

Why are you using .Fields and why are you using the val function?

Just compare the field value for the current record to a variable or constant.

If Rst![DuesPaidYear] >= 14 Then

[orange]

In addition to ItsMe comment, you could investigate using a DateTime data type for Dates.

Also there is Year function to get the Year from today's date Today's date is Date in Access

currentYear = Year(Date) , similarly for month CurrentMonth = Month(Date)

[ynotaz]

I did make the changes to use "date", "year", and "Month" in the routine and it works....

THANKS for the help it is much more straightforward.....

[orange]

Happy to help. Good luck with your project.