Albert's got the right idea for the WHERE clause. Actually, even better would be IYR4, in which case your date format setting wouldn't matter.
Albert Berry wrote: > WHERE (IYR(TheYearCol)) <= 2035
Albert's got the right idea for the WHERE clause. Actually, even better would be IYR4, in which case your date format setting wouldn't matter.
Albert Berry wrote: > WHERE (IYR(TheYearCol)) <= 2035