IIf statement and age

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Philip Wright - 31 Jul 2006 18:36 GMT

I'm wanting to calculate an age either by date of death or current date in a
query. How do I do this?

I currently have expressions to calculate current age, but if a patient is
deceased, I want it to display age at death instead of the current age.

Thanks.

Philip Wright

Reply to this Message

Klatuu - 31 Jul 2006 18:57 GMT

within your existing code,

IIf([DateOfDate] IS NULL, Date(), [DateOfDeath])

Just change DateOfDeath to the field name in your table that carries this
data.

> I'm wanting to calculate an age either by date of death or current date in a
> query. How do I do this?
[quoted text clipped - 5 lines]
>
> Philip Wright

Reply to this Message

Douglas J. Steele - 31 Jul 2006 19:17 GMT

I don't think you can use IS NULL in the IIf statement. Try:

IIf(IsNull([DateOfDate]), Date(), [DateOfDeath])

Of course, this is exactly what the Nz function is for:

Nz([DateOfDate], Date())

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> within your existing code,
>
[quoted text clipped - 14 lines]
>>
>> Philip Wright

Reply to this Message

Klatuu - 31 Jul 2006 19:25 GMT

In VBA you can't. In SQL you can.

> I don't think you can use IS NULL in the IIf statement. Try:
>
[quoted text clipped - 22 lines]
> >>
> >> Philip Wright

Reply to this Message

Philip Wright - 31 Jul 2006 20:06 GMT

Thanks for the help. The Nz function worked as I wanted.

> I don't think you can use IS NULL in the IIf statement. Try:
>
[quoted text clipped - 22 lines]
> >>
> >> Philip Wright

Reply to this Message