R
RIP
I've googled this problem to death. Hopefully someone here can help.
I have a graph that uses the X-Axis containing decimal values, i.e., but
when I run the SQL, the decimals get replaced with unserscores and the data
is skipped in the graph.
Is there a way to force the Column Headers to use decimals?
I can manually change the values while editing the underlying datasheet, but
I'm at a loss to perform this task programmatically.
Here is the code which is the RowSource of the graph:
TRANSFORM Avg([Motor Data].[100% Eff (%)]) AS [AvgOf100% Eff (%)]
SELECT [Motor Data].Model
FROM [Motor Data]
WHERE ((([Motor Data].Manufacturer)='GE') AND (([Motor Data].Poles)=2))
GROUP BY [Motor Data].Poles, [Motor Data].Model
PIVOT [Motor Data].HP;
and the resulting table looks like this (first 10 columns):
Model 1 1_5 2 3 5 7_5 10
15 20 ...
Ultra 88.7 90.9 91.2 91.5 91.7
91.9 92.6 ...
Ultra 841 89 89.4 88.7 90.9 91.2 91.4 91.5
91.8 92.5 ...
the culprits are 1_5 and 7_5 which should display as 1.5 and 7.5
respectively... The fields are set as DOUBLE and I've tried using
FORMAT([HP],"000.0") which produces the same result...
I've switched the Column and Row Headings but I can't graph the resultant
data since the Model Name becomes the Column Header... any help is
appreciated.
I have a graph that uses the X-Axis containing decimal values, i.e., but
when I run the SQL, the decimals get replaced with unserscores and the data
is skipped in the graph.
Is there a way to force the Column Headers to use decimals?
I can manually change the values while editing the underlying datasheet, but
I'm at a loss to perform this task programmatically.
Here is the code which is the RowSource of the graph:
TRANSFORM Avg([Motor Data].[100% Eff (%)]) AS [AvgOf100% Eff (%)]
SELECT [Motor Data].Model
FROM [Motor Data]
WHERE ((([Motor Data].Manufacturer)='GE') AND (([Motor Data].Poles)=2))
GROUP BY [Motor Data].Poles, [Motor Data].Model
PIVOT [Motor Data].HP;
and the resulting table looks like this (first 10 columns):
Model 1 1_5 2 3 5 7_5 10
15 20 ...
Ultra 88.7 90.9 91.2 91.5 91.7
91.9 92.6 ...
Ultra 841 89 89.4 88.7 90.9 91.2 91.4 91.5
91.8 92.5 ...
the culprits are 1_5 and 7_5 which should display as 1.5 and 7.5
respectively... The fields are set as DOUBLE and I've tried using
FORMAT([HP],"000.0") which produces the same result...
I've switched the Column and Row Headings but I can't graph the resultant
data since the Model Name becomes the Column Header... any help is
appreciated.