If date field is older than so many months, show text string. (1 Viewer)

Hi All, keep in mind i'm a beginner at access and this is my first post. Please do help if you can.

I'm trying to do a calculation on a date that contains certification dates of employees, then return text if criteria is met. If the certification date is 12 months or older, it is expired. If the certification date is older than 10 months but less than 12, it needs re-certification.

I had a query working with the Field shown below, but now it just returns #Error:

Thanks

I think what you want is
IIf([Certification Date]<=DateAdd("m",-12,Date()),"expired",IIf([Certification Date]<=DateAdd("m",-10,Date()),"Needs ReCert","NA"))

CJ you're my hero!!!!!! Thanks.