M
miles4163
When I use a calculation in a query, I would sometimes like to display the
result as a floating decimal and set the DecimalPlaces property to "2" at the
same time.
For Example:
Result = 4.33333333333333
Display = 4.33
Result = 4
Display = 4 (Not 4.00)
This could be resolved by allowing the decimal place to be optional in a
custom number format.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...ecd6e9d168&dg=microsoft.public.access.queries
result as a floating decimal and set the DecimalPlaces property to "2" at the
same time.
For Example:
Result = 4.33333333333333
Display = 4.33
Result = 4
Display = 4 (Not 4.00)
This could be resolved by allowing the decimal place to be optional in a
custom number format.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...ecd6e9d168&dg=microsoft.public.access.queries