Better get hold of a white paper by Ken Getz on Dates and Time in Access. Check for Ken Getz at the FMS Website. that article seems to be very good on dates and time in access. It is rather not straight forward in access97. in access 2000 the situation is better.

Gotora