Not Rounding (1 Viewer)

Access_Help

Registered User.
Local time
Today, 06:41
Joined
Feb 12, 2005
Messages
136
Despite the use of the round function and the textbox control set to fixed to 0 decimal points, still showing ### and not rounding

=Round(Sum(IIf([Year_Group]="2013",[A])),0)/[Text73]*100 & "%"

:banghead:
 

June7

AWF VIP
Local time
Today, 05:41
Joined
Mar 9, 2014
Messages
5,425
Only want to Round the numerator?

The IIf does not have value for the False result. Looks like ) is misplaced.

Those property settings are ignored because you are concatenating text, therefore the result is text not a number. Use Percent instead of Fixed.
 
Last edited:

Users who are viewing this thread

Top Bottom