Introducing a condition into an expression

[Winefride]

I have an expression eg Expr1: [Donor1First Name] & " and " &
[Donor2FirstName]
I dont want the word "and" to appear if [Donor2FirstName] is null.
Any ideas?
Thanks in advance for any help.

 

[Klatuu]

Expr1: [Donor1First Name] & IIf(IsNull([Donor2FirstName]),""," and " &
[Donor2FirstName])

 

[fredg]

I have an expression eg Expr1: [Donor1First Name] & " and " &
[Donor2FirstName]
I dont want the word "and" to appear if [Donor2FirstName] is null.
Any ideas?
Thanks in advance for any help.

There are a couple of ways.
1)
Expr1:IIf(IsNull([Donor2FirstName]),[Donor1firstName],
[Donor1FirstName] & " and " & [Donor2FirstName])

or you could use:

Expr1:[Donor1FirstName] & (" and " + [donor2FirstName])

 

[Winefride]

Thank you very much.
--
Winefride

Expr1: [Donor1First Name] & IIf(IsNull([Donor2FirstName]),""," and " &
[Donor2FirstName])
--
Dave Hargis, Microsoft Access MVP

I have an expression eg Expr1: [Donor1First Name] & " and " &
[Donor2FirstName]
I dont want the word "and" to appear if [Donor2FirstName] is null.
Any ideas?
Thanks in advance for any help.

 

[Winefride]

Thank you very much.
--
Winefride

I have an expression eg Expr1: [Donor1First Name] & " and " &
[Donor2FirstName]
I dont want the word "and" to appear if [Donor2FirstName] is null.
Any ideas?
Thanks in advance for any help.

There are a couple of ways.
1)
Expr1:IIf(IsNull([Donor2FirstName]),[Donor1firstName],
[Donor1FirstName] & " and " & [Donor2FirstName])

or you could use:

Expr1:[Donor1FirstName] & (" and " + [donor2FirstName])