Need help with IIf

[Sandy]

Hello -

I want to say if the value is 1, write "Home", if it's 2, write "Business",
if it's 3, write "Both.

Any help will be greatly appreciated!

 

[Newbie]

=iif([yourfield] = 1, "Home", iif([yourfield] = 2, "Business", "Both"))

HTH
Ali

 

[Sandy]

Hello Newbie -

Thanks for your response. Your answer is exactly what I tried before
posting. I get "#Error" on my report from this.

It's got to be something stupid . . .
--
Sandy

=iif([yourfield] = 1, "Home", iif([yourfield] = 2, "Business", "Both"))

HTH
Ali

Hello -

I want to say if the value is 1, write "Home", if it's 2, write
"Business",
if it's 3, write "Both.

Any help will be greatly appreciated!

 

[BruceM]

Is [yourfield] a number field? If it is a text or memo field you will need
to put the values inside double quotes in your IIf statement. Where are you
putting this IIf statement? It should work as the control source of a text
box, or as a calculated field in a query.

Hello Newbie -

Thanks for your response. Your answer is exactly what I tried before
posting. I get "#Error" on my report from this.

It's got to be something stupid . . .
--
Sandy

=iif([yourfield] = 1, "Home", iif([yourfield] = 2, "Business", "Both"))

HTH
Ali

Hello -

I want to say if the value is 1, write "Home", if it's 2, write
"Business",
if it's 3, write "Both.

Any help will be greatly appreciated!

 

[Marshall Barton]

Thanks for your response. Your answer is exactly what I tried before
posting. I get "#Error" on my report from this.

The usual reason for that error is that the text box is
named the same as the field in the expression.

 

[Sandy]

Hi Bruce -

Thanks for your reply. I'm putting it in as a control source for a textbox.
I did try it both with and without the quotes - neither worked (although it
should have the quotes because it is a text field). Could something be
corrupted?

--
Sandy

Is [yourfield] a number field? If it is a text or memo field you will need
to put the values inside double quotes in your IIf statement. Where are you
putting this IIf statement? It should work as the control source of a text
box, or as a calculated field in a query.

Hello Newbie -

Thanks for your response. Your answer is exactly what I tried before
posting. I get "#Error" on my report from this.

It's got to be something stupid . . .
--
Sandy

=iif([yourfield] = 1, "Home", iif([yourfield] = 2, "Business", "Both"))

HTH
Ali
Hello -

I want to say if the value is 1, write "Home", if it's 2, write
"Business",
if it's 3, write "Both.

Any help will be greatly appreciated!

 

[Sandy]

Marshall -

Thanks so much for your response! That was the problem!