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 Gostap
Hi you can use datediff function of the access while reteriving the record and check for the dirrerence