Access 2003 - Format Decimal Numbers into a whole number in a report.
Posted on 2006-07-20
I have a query where one of it's fields is a percentage in decimal numbers and I want to make this decimal number when it appears in the report a whole number with no decimal places.
I tried formating it in the property section of the report and I set the property called "Format" to "Percent" and set the "Decimal Places" property to "0" so that it wouldn't show any decimal places but this is not what happened. Then I changed in to "General Number" and "Auto" and that gave me two decimal places or something like that.
Can anyone tell me the correct way to set these properties so that I will get a whole number for the percent value and no decimal places.
Thanks again in advance for everything.