I am trying to format the data table of a chart in Access 2010 to show numbers with the thousands separator but no decimal places. In Design View the data table of the chart shows the thousands separator correctly.
Example: 1,271 3,660 1,004 etc.
I have the following expression in the Query Builder in the Chart Row Source property:
Expr1: Sum(Format([SumOfSALES],"#,##0")). This is successfully eliminating the decimal places to show whole number values.
However, when I switch to Print Preview mode, it does not show the thousands separator for some strange reason.
Example: 1271 3660 1004 etc.
For whatever its worth, here is the entire SQL expression in the field mentioned above.
TRANSFORM Sum(Format([SumOfSALES],"#,##0")) AS Expr1
SELECT SummaryForChart.INVENMONTH
FROM SummaryForChart LEFT JOIN MonthLookup ON SummaryForChart.INVENMONTH = MonthLookup.MonthName
GROUP BY MonthLookup.MonthNumber, SummaryForChart.INVENMONTH
ORDER BY MonthLookup.MonthNumber
PIVOT SummaryForChart.INVENYEAR;
I have wasted several hours trying to find a solution but nothing has worked. Does someone have a solution?