expressions in a qry

[lwarren1968]

i need to write an expression that combines several groups of fields, however if any of the "last name" fields are empty I do not want to include that group? Thoughts?


=[merchant no 1] & " " & [first name1]& " " & [last name1] & " " & [merchant no 2]& " " & [first name2] & " " [last name2]

 

[Beetle]

What is the structure of the underlying table(s)? Do you actually have fields like;

Merchant, Merchant 2, Merchant 3
First Name 1, First Name 2, First Name 3

etc.?

 

[lwarren1968]

trying this again. I somewhat figure it out and it worked on my first set of fields, but it did not work on the second set. I figured I'd just break down and then combined all. Although my [Value 2] is blank the expression return all but the [Value 2] field? it should not of returned any data?


Expr2: IIf(([Value 2]) Is Not Null,[,sw_] & " " & [label 2] & " " & [=1] & " " & [value 2])