How to eliminate text adjacent to field when field has no data?

[jmuirman]

This is in my query --- FirstPayDateAge: [FirstPay1] & " at age " & [BegAge]

When I don't want to put a date in the [FirstPay1] field, how can I
eliminate the text ---- "at age"?

(1) Here's the way it looks when I enter a date in [FirstaPay1]: 10/1/2015
at age 45

(2) Here's the way it looks when I leave[FirstaPay1] blank: at age

Thanks,

John

 

[Douglas J. Steele]

FirstPayDateAge: IIf(IsNull([FirstPay1]), "", [FirstPay1] & " at age " &
[BegAge])

 

[jmuirman]

It works!! Awesome!

Thank you!

John

FirstPayDateAge: IIf(IsNull([FirstPay1]), "", [FirstPay1] & " at age " &
[BegAge])

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

This is in my query --- FirstPayDateAge: [FirstPay1] & " at age " &
[BegAge]

When I don't want to put a date in the [FirstPay1] field, how can I
eliminate the text ---- "at age"?

(1) Here's the way it looks when I enter a date in [FirstaPay1]: 10/1/2015
at age 45

(2) Here's the way it looks when I leave[FirstaPay1] blank: at
age

Thanks,

John