f



Why won't this work? (can't find prior posting of this problem)

I have a control on a form whose data source is:

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

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


and

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

The problem is that I never get the "Total is 100%" message, even when
it's 1.  I have tried adding the 14 values in Excel and they come to
1.00.  I have put the decimal places to 4 and 5 and it's all zeroes.

I typed the values into the table and want (ultimately) to enter them
via  a form.

Thanks
Sara

0
saraqpost (288)
1/31/2007 11:36:37 PM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

1 Replies
1363 Views

Similar Articles

[PageSpeed] 34

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

0
2/1/2007 8:50:18 AM
Reply: