Code:
strSQL = "insert into rates ([customer], [ratecode], [saturdaystart], [fridayend], [rate]) values (""" & [findcust] & """, 'L', " & [LastSaturday] & ", " & [LastFriday] & ", " & Me.RateperHour & ")"
CurrentDb.Execute strSQL, dbFailOnError
On debugging, I see that value of [LastFriday] is definitely greater than the value of [LastSaturday]. However, this table validation rule error occurs: [fridayend]>[saturdaystart], and Msg = End Date must be Greater than Start Date