If the date in the field was 31/01/2006, your expression would return
a value of (2006 + 1) = 2007, which, as a date value, is 29/06/1905.
DateAdd("yyyy",1,[[MOT Expiry Date])
will add one year to whatever the date field is.
A criteria of <Date() will affect only records before today, not
Please respond only to this newsgroup.
I do not reply to personal e-mail