WHat IIF need a little more Please?

  • Thread starter Thread starter Javes
  • Start date Start date
J

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
 
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
Click to expand...

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

- Jim
 
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
Click to expand...

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

- Jim
.
Click to expand...
 
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
Click to expand...

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.
 
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
 
Javes said:
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.
Click to expand...
You may want to try Me!textbox1 but if both fields are available in the
query the IIF will do what you want.
 
Back
Top