Aarrrgh!! Why won't this work?

[sara]

I have a text box on a form whose control source is

=IIf([txtPercentTotal]>1,"Total is Over 100%; Please
Adjust",IIf([txtPercentTotal]<1,"Total is UNDER 100%; Please
Adjust","Total is 100%"))

I have also tried
=IIf([txtPercentTotal]>1,"Total is Over 100%; Please
Adjust",IIf([txtPercentTotal]<1,"Total is UNDER 100%; Please
Adjust",IIf([txtPercentTotal]=1,"Total is 100%")))
and

=IIf([txtPercentTotal]=1,"Total is
100%",IIf([txtPercentTotal]>1,"Total is Over 100%; Please
Adjust",IIf([txtPercentTotal]<1,"Total is UNDER 100%; Please
Adjust")))

The problem is that I don't get the "Total is 100% message" and the
total is 100%. I can adjust one of the 14 figures and correctly get
the OVER and UNDER messages, but the Equals message won't work.

I've added the values in Excel. Each field is defined as double. I
typed in the values that are being added right into the table (and
they will eventually come from a form). I have expanded the field
to 4 and 5 positions after the decimal - all are zeroes.

I just can't figure this out!

thanks
Sara

[Smartin]

sara wrote:

I have a text box on a form whose control source is

=IIf([txtPercentTotal]>1,"Total is Over 100%; Please
Adjust",IIf([txtPercentTotal]<1,"Total is UNDER 100%; Please
Adjust","Total is 100%"))

I have also tried
=IIf([txtPercentTotal]>1,"Total is Over 100%; Please
Adjust",IIf([txtPercentTotal]<1,"Total is UNDER 100%; Please
Adjust",IIf([txtPercentTotal]=1,"Total is 100%")))
and

=IIf([txtPercentTotal]=1,"Total is
100%",IIf([txtPercentTotal]>1,"Total is Over 100%; Please
Adjust",IIf([txtPercentTotal]<1,"Total is UNDER 100%; Please
Adjust")))

The problem is that I don't get the "Total is 100% message" and the
total is 100%. I can adjust one of the 14 figures and correctly get
the OVER and UNDER messages, but the Equals message won't work.

I've added the values in Excel. Each field is defined as double. I
typed in the values that are being added right into the table (and
they will eventually come from a form). I have expanded the field
to 4 and 5 positions after the decimal - all are zeroes.

I just can't figure this out!

thanks
Sara

Just guessing, maybe a conversion error? You know, decimal numbers are
stored in an imprecise hexidecimal manner. Adding them up sometimes
results in weird and unexpected results.

Maybe try doing a debug.print txtPercentTotal.value and see what you
actually have there. It might look like 1.00000000014124 or something
equally crazy.

--
Smartin
Your message was received. Your message was received. Your message was
received.

[Keith Wilby]

"sara" <sa*******@yahoo.comwrote in message
news:11**********************@m58g2000cwm.googlegr oups.com...

Just a hunch but try

=IIf(CInt([txtPercentTotal])>1,"Total is Over 100%; Please
Adjust",IIf(CInt([txtPercentTotal])<1,"Total is UNDER 100%; Please
Adjust","Total is 100%"))

You say how you're trying to do something but not *what* you're trying to
do. You never know, someone may have an existing or even better method of
achieving your goal.

Regards,
Keith.
www.keithwilby.com