IIf Function?

[Guest]

I have 6 text fields labled Eqp1, Eqp 2,...etc. I want to combine the data
in the fields starting with Eqp6 and working backwards. All of the fields do
not contain data. The end result should look like:
Field 6 text * Field 5 text * Field 4 text* etc.....

Can anyone help me write this for my qry in the simplist way? I tried using
nested IIf, but I'm leaving something out and getting an error message in the
expression builder.

 

[Guest]

Try something like

[Field 6] + "*" & [Field 5] + "*" & [Field 4] + "*" & [Field 3] + "*" &
[Field 2] + "*" & [Field 1] + "*"

 

[Marshall Barton]

I have 6 text fields labled Eqp1, Eqp 2,...etc. I want to combine the data
in the fields starting with Eqp6 and working backwards. All of the fields do
not contain data. The end result should look like:
Field 6 text * Field 5 text * Field 4 text* etc.....

Can anyone help me write this for my qry in the simplist way? I tried using
nested IIf, but I'm leaving something out and getting an error message in the
expression builder.

The expression wizard just gets in my way, so I just trye
the expression.

Mid(("*" + F6) & ("*" + F5) & ("*" + F4) & ... , 2)