Unanswered: Limiting Decimal Places in a Calculated Query Field
I'm trying to display the results of a query in a stacked bar chart, and the numbers (in the tens of thousands) are too large. I tried dividing them by 1,000 to make them smaller, but now the decimal places make up the spaces. In some cases the decimals repeat for as many as seven spaces.
I tried opening the query in design form, clicking the calculated field, and setting Properties > General > Decimal Places > 2.