I have a graph that shows variation of temperature during the day.

Along the x-axis, the date and time is shown in 12h time. I think this is the problem.

The graph normally starts showing values around 01, a time which shouldn´t have any values (none are collected during the nights). The graph then moves on over the day and it looks fine, except it ends with some values around 21.

The data is collected between 09.30 and 17.30.

I think the problem is access interprets the values around 13 as being around 01 (due to the 12h time) and also the values that should be around 09 as being around 21.

If this is the problem, I would like to know how to format the date and time to show 24h time.

If not, I would like to know what´s going on.

Fuga.

Lookup the Format function.

[This message has been edited by llkhoutx (edited 05-29-2002).]

Thanks! I got it to work.

(If someone is wondering dddd tt:NnSs)

Could someone please tell me why access had set it to dddd t:nnampm?

Fuga.