IIf Function?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

2Blessed4Stress - 31 Oct 2007 22:44 GMT

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.

Reply to this Message

Ofer Cohen - 31 Oct 2007 23:13 GMT

Try something like

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

Signature

Good Luck
BS"D

> 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
[quoted text clipped - 4 lines]
> nested IIf, but I'm leaving something out and getting an error message in the
> expression builder.

Reply to this Message

Marshall Barton - 31 Oct 2007 23:56 GMT

>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
[quoted text clipped - 4 lines]
>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)

Signature

Marsh
MVP [MS Access]

Reply to this Message