compare dates in forms

Gostap's Avatar
Newbie Member
Hi there

A question from a newbie, hope some one could help me.

I have a table with some date fields in among others.
One field is called “Start production” and another is called “Stop production”
I want to do a comparison between “Stop production” and “Start production” at the NEXT Next record! It is meant to get an msgBox with a warning if time between “Stop production” and “Start production” at next record exceed e.g. 5 minutes

recID Start production Stop production

1011 2007-10-01 15:33 2007-10-01 16:11
1012 2007-10-01 16:12 2007-10-01 18:32
1013 2007-10-01 18:41 2007-10-01 19:13
1014 2007-10-01 19:14 2007-10-01 21:36

I hope it is not too messy!

Best Regards

caveatashish's Avatar, Join Date: Dec 2007
Newbie Member

you can use datediff function of the access while reteriving the record and check for the dirrerence