OfficeFrustration

OfficeFrustration (http://www.officefrustration.com/index.php)
-   Setting Up & Running Reports (http://www.officefrustration.com/forumdisplay.php?f=26)
-   -   conditional numeric formatting of field output on report (http://www.officefrustration.com/showthread.php?t=626305)

David McCormack[_2_] June 7th, 2010 06:52 AM

conditional numeric formatting of field output on report
 
Marshall,

Thank you for the help. It didn't help out completely, but it got me in the
right direction and I was able to get my report to work properly.

"Marshall Barton" wrote:

David McCormack wrote:

I have tried this but I keep getting an error. This is what I have:

=IIf([Operation]=2,Format([May], "##0.0"),Format([May], "##0.0%"))

I have a field that if the object [Operation] is equals to 2, I need the
field to be in a standard number format with one decimal place. Otherwise I
need the field to be in a percentage format with one decimal place.



I don't see a problem with the expression. If your error is
that the text box displays #Error, then try changing the
name of the text box to something other than the nae of a
field in the report's record source (eg. txtMay).

--
Marsh
MVP [MS Access]
.



All times are GMT +1. The time now is 02:48 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
OfficeFrustration.com