Concatenate 2 Fields In a Query

[NeonSky via AccessMonster.com]

Hello All!

Ok, we have field "A" and field "B". If field "B" not null then concatenate
in query results, seperated by a space, within field "A".

Happy to provide additional information.

As always thanks a million!

 

[Ken Snell \(MVP\)]

MyResult: [FieldA] & (" " + [FieldB])

 

[Douglas J. Steele]

What do you mean by "concatenate ... within field 'A'"? Can you give an
example?

Generically, you're going to need to use the IIf statement, with IsNull as
the condition in the first part of the statement.

 

[NeonSky via AccessMonster.com]

Thanks this does it wonderfully.

MyResult: [FieldA] & (" " + [FieldB])

Hello All!

[quoted text clipped - 5 lines]

As always thanks a million!