annoying time problem

[wh00t]

I have a databse which is used for logging information about deliveries.

Each delivery is automatically given a booking time, after the delivery the user is required to enter an arrival time, if the driver arrives late, the user is then prompted to enter a reason why it was late.

If the booking time is 00.** and the driver arrives early say 23.45, the database then asks the user to enter a reason for being late.

how would I be able to get the database to recognise these instances as being early instead of late?

 

[suepowell]

Hi,

Could you set the automatic delivery time to include the date, and maybe have a date field defaulting to todays date on the form where the arrival is recorded. Then if the arrival was before midnight instead of after, the date would still be correct. You would of course have to include date as well as time in your comparison to see if the delivery was late.


Sue