Status query by date (1 Viewer)

I currently have a status query in my database to automatically show an individuals status "Current", "Suspended", "Expired" based on the date of their last exam.

I'm trying to get a fourth status to show, but haven't had any luck with the code. I am using MS Access 2013.

I currently show "CURRENT" for those whose date is less than 180 days, "SUSPENDED" if their date is between 181 and 365 days and Expired if over 365 days.

What I am trying to do is show Expired for dates between 365 and 730 days and add an "INACTIVE" status for those 731 days or greater... I haven't had much luck... below is what I am using right now and it works great, but trying to expand the status.

Status: IIf(DateDiff("d",[Cert_CurrencyDate],Date())<=180,"CURRENT",IIf(DateDiff("d",[Cert_CurrencyDate],Date())>=181 And DateDiff("d",[Cert_CurrencyDate],Date())<365,"SUSPENDED","EXPIRED"))

Thanks in advance for any help.
Nathan

instead of building nested IIFs, in the query ,qsData, make an extra field for DAYSateDiff("d",[Cert_CurrencyDate],Date())

then make another query based on the above query qsData, that has your limits, but now its:
IIf([Days])<=180, "CURRENT", IIf([Days]>=181 And [Days]<365), "SUSPENDED",IIf([Days]>365 And [Days]<730), "INACTIVE","EXPIRED")))


OR
You can build a custom function to get the results. place this code into a module.
usage in query:
STATUS: getStatusDays([Days])

Ranman256 got here faster than me but I'll give you my version anyway.




Demo database attached

Thanks to all... they all worked... I'm fairly new to Access and trying to teach myself... So I appreciate the quick and useful responses.