ahoneycutt
New member
- Local time
- Today, 02:39
- Joined
- Mar 31, 2015
- Messages
- 9
I have a field that comes from a make-table and is set to Double. This field is used to display different types of values like .994965 as well as 47 and 1.08. So changing the field type is not an option to meet my need.
I need to display all the data that reads .994965 or any number similar to that and display it as a percentage on a report which is working fine except the reader needs to see the actual number and not the rounded one. For example, .994965 I need to read as 99.49%.
The report is using a Switch function to determine how to display that field on the report. It is applying the FormatPercent function to this field with 2 decimal places. Therefore, it changes the number to read, 99.50% which is correct, however, I need it to read, 99.49%.
I understand that .994965 is truly 99.50% but for this situation the view needs to read it without the rounding.
I can't change the formatting of the table but can change a query or the report.
Is there any other method of displaying this number as a percentage without Access actually converting it to a percentage?
Any suggestions would be greatly appreciated.
I need to display all the data that reads .994965 or any number similar to that and display it as a percentage on a report which is working fine except the reader needs to see the actual number and not the rounded one. For example, .994965 I need to read as 99.49%.
The report is using a Switch function to determine how to display that field on the report. It is applying the FormatPercent function to this field with 2 decimal places. Therefore, it changes the number to read, 99.50% which is correct, however, I need it to read, 99.49%.
I understand that .994965 is truly 99.50% but for this situation the view needs to read it without the rounding.
I can't change the formatting of the table but can change a query or the report.
Is there any other method of displaying this number as a percentage without Access actually converting it to a percentage?
Any suggestions would be greatly appreciated.