Percent Rounding (2kProSR1a)

Topic

New Reply

Sorry folks … I know this has been previously asked and answered but I can’t find it.

The simple question is: What do I have to do in formatting a percent field to get it to display as entered? Entering “.75” or “.25” results in displays of 100% and 0%. I’ve tried standard/2 places*100; percent 2 places; percent 4 places with no luck. What’s the trick (beyond making it a text field which is admitting defeat)?

Sorry for the “Senior Moment”, but I’m stuck.

Thanks much

Reply | Quote

Replies

Just a guess but try checking your fields data type in the table. An Interger type will always show whole numbers, you want a double.

HTH

Peter

Reply | Quote

Peter:

You’re absolutely correct. I forgot about the “double” formatting, then kicked myself when you reminded me.

Thanks again,

Reply | Quote

First of all, *where* are you trying to display it? Is this in a form, a table, a query, a report or what? Second, what type of number did you select for the underlying field, assuming this is in a table or query? You’ll can select as single or a double, but I would recommend chosing Currency as your datatype if you want no more than 2 decimal places. The Currency format will hold 4 decimals, so you can represent decimal fractions up to n.99% using the currency format and you won’t have the floating point issues to deal with if you need to do calculations with the values.

Reply | Quote

Charlotte:

Thanks for the response.

Peter’s response jogged my memory and solved the problem.

Reply | Quote