WHat IIF need a little more Please?

[Javes]

Hi All thanks for the help so far you have taught me so
much but I guess this is only code that works to compare
two textboxes and output the results in another.

The follwing code is great if the two fields are not
matching....

= IIF([Textbox1] = [Textbox2], [Textbox1], "UNBALANCED")

I would like to know what I can ADD to this if it does
match because if Textbox1 does equal Textbox2 I want it
then to show the Amount from textbox1 or textbox2.

Please HELP!!!!
Thanks all you great people.

Javes

 

[Jim Allensworth]

Hi All thanks for the help so far you have taught me so
much but I guess this is only code that works to compare
two textboxes and output the results in another.

The follwing code is great if the two fields are not
matching....

= IIF([Textbox1] = [Textbox2], [Textbox1], "UNBALANCED")

I would like to know what I can ADD to this if it does
match because if Textbox1 does equal Textbox2 I want it
then to show the Amount from textbox1 or textbox2.

Please HELP!!!!
Thanks all you great people.

Javes

?? What you have should work just fine.
Textbox1 = (Textbox1 Or Textbox2)

- Jim

 

[Javes]

Hi,

Thanks, than this retard newbie really newbie must ask...

Where do I put it...I currently followed instructions and
put it in the 3rd Textbox.

When the textbox 1&2 are balanced there is an #Error.

Please help.

Thx Javes

-----Original Message-----

Hi All thanks for the help so far you have taught me so
much but I guess this is only code that works to compare
two textboxes and output the results in another.

The follwing code is great if the two fields are not
matching....

= IIF([Textbox1] = [Textbox2], [Textbox1], "UNBALANCED")

I would like to know what I can ADD to this if it does
match because if Textbox1 does equal Textbox2 I want it
then to show the Amount from textbox1 or textbox2.

Please HELP!!!!
Thanks all you great people.

Javes

?? What you have should work just fine.
Textbox1 = (Textbox1 Or Textbox2)

- Jim
.

 

[fredg]

Hi All thanks for the help so far you have taught me so
much but I guess this is only code that works to compare
two textboxes and output the results in another.

The follwing code is great if the two fields are not
matching....

= IIF([Textbox1] = [Textbox2], [Textbox1], "UNBALANCED")

I would like to know what I can ADD to this if it does
match because if Textbox1 does equal Textbox2 I want it
then to show the Amount from textbox1 or textbox2.

Please HELP!!!!
Thanks all you great people.

Javes

Did you try your expression?
It should do what you are asking as it is written.
If [Textbox1] does = [TextBox2] it will print the value of [Textbox1],
otherwise it will print the word "Unbalanced".

Perhaps you should read up on the IIF() function in VBA help.

 

[Javes]

I really suck...I tried it again and finally after
wasting everyone's time I understand.

Thank you so much for all your precious time.

Sincerely,

Javes

 

[Mike Painter]

Hi All thanks for the help so far you have taught me so
much but I guess this is only code that works to compare
two textboxes and output the results in another.

The follwing code is great if the two fields are not
matching....

= IIF([Textbox1] = [Textbox2], [Textbox1], "UNBALANCED")

I would like to know what I can ADD to this if it does
match because if Textbox1 does equal Textbox2 I want it
then to show the Amount from textbox1 or textbox2.

You may want to try Me!textbox1 but if both fields are available in the
query the IIF will do what you want.