Query - Status Upon Date

Hi there,

i am writing a query that calculates a date

ExpiryDate: DateAdd("yyyy",[NATATable].[NATAExpiryPeriod],[NATATable].[NATADate])

which works

The expiry period is always 2 or 4 and the natadate is a date i want it to add 2 or 4 years to the date the NATA was done... works no problems.

Now i want a query in another field as a status

ExpiryStatus: Expired or Valid

ExpiryStatus: IIf([ExpiryDate]>=Now(),"Expired", "Valid")

Which works

i am ultimatley aiming to end up with 3 Fields - Expiry date (working), Status (working) and Remark (not working)

Remark is based on this excel query

=IF(AL3<NOW(),(IF(AL3<(NOW()-365/4),"(3) Expired more than 3 months ago","(2) EXPIRED during last 3 months")),(IF(AL3<(NOW()+365/4),"(1) Expires within next 3 months","(4) Expires in more than 3 months time")))

which i need to change to an acess query.
Where AL3 is the expiry date.
Please help

Thanks

Kris