I have three date fields, EffectiveDate, DisconnectDate, and SuspendDate.  I
want to create a status field where the result will be Active, Inactive, or
Suspended based on whether there is a date in the field.  What is the SQL
Statement needed to accomplish this in an Access Project?

Status                  EffectiveDate               DisconnectDate
SuspendDate
Active                  Has Date                     Is Null
Is Null
Inactive                Has Date                     Has Date
May or May not have date
Suspended           Has Date                     Is Null
Has Date

Thank you in advance for your assistance.

John