Hi,

Having a problem creating my access trending charts. I've created a query that contains the data that I want to display in my charts.

CODE
SELECT tblParameters.Parameter_name, Readings.Time, Readings.Value, Equipment_info.Unit_name... blah blah blah... where blah blah (the rest of the code doesn't matter)


I created a chart object that draws its data from this query. The x axis of the chart is supposed to show the time. The Time field inside my table shows 01:00, 02:00.. short time..
But when I open up my chart object, it shows date and time. And the dates are all in 1899! I tried to work around it by formatting the time inside my query, but then the error incompatible data types kept popping up

How can I format the time on the chart to show short time?

Jamie