[AccessD] Chart X Axis problem

I have data that has a time step of hourly. I used the chart wizard to build my chart. It generated the following query.

SELECT (Format([DateTime],"DDDDD HAMPM")),
[qry Plant Pressure Temperature Data].Actual,
[qry Plant Pressure Temperature Data].[Target Limits] AS [Lower Limit],
[qry Plant Pressure Temperature Data].Target, [qry Plant Pressure Temperature Data].HighRangePressure AS [Upper Limit]
FROM [qry Plant Pressure Temperature Data]
GROUP BY (Format([DateTime],"DDDDD HAMPM")),
[qry Plant Pressure Temperature Data].Actual,
[qry Plant Pressure Temperature Data].[Target Limits],
[qry Plant Pressure Temperature Data].Target,
[qry Plant Pressure Temperature Data].HighRangePressure,
(Int([DateTime]*24)) ORDER BY (Int([DateTime]*24));

The X axis displays labels with both date and time. I have the interval set to 24 which works fine for one label each day. However I cannot format the label from the chart axis or the chart datasheet to display only the data without the time. Is this possible?

Thanks.


Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799





No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.