Nested IIF problem

Hi

[PayReceived] is a tick box on a form from a subscriptions table.
[DateDifference] calculates the number of dates between the [DueDate] and
Today’s Date to work out if the subscription payment is overdue by 30 days or
more and [MembStatus] holds a string depending on how many days overdue the
payment is.

I am having problems with the nested IIf statement which should calculate
[MembStatus] and no matter what I do I either get a syntax error, too many
brackets error or an error about commas – and I’ve been trawling through the
questions and answers on this subject and tried this so many different ways
but can't seem to get it right.

I’ve had problems with even the simplest calculations which then suddenly
seems to update and expressions that did not work previously suddenly work so
I’m beginning to get a little paranoid – is anyone else having trouble with
Access? I was using Vista but upgraded to Windows 7 because of other
problems I was having with other programs not updating (Windows Update and
AVG to name 2).

This is what I’m trying to accomplish: [MembStatus] =

If PayReceived = False AND
DateDifference is between 30 and 60 = “Active�
DateDifference is 60 but =90 = “Pending�
DateDifference is 90 but =120 = “Suspended�
DateDifference is 120 but =150 = “Inactive�
DateDifference is 150 = “CLOSED�
Else “Active�

Thank you in anticipation

TheBrat