Checking value from previous record

[KirkD]

I have a time sheet that keeps track of task preformed during the each shift. They record the task, startTime, and stopTime. When they enter the next task I want to make sure it starts on or after the stopTime from the previous record.

record 1 startTime = 7:00 stopTime = 7:30

record 2 startTime must be >= stopTime from the previous record.

Edited January 25, 2008 by Guest

[KirkD]

Never mind. I think I answered my own question.

GetNthRecord ( fieldName ; recordNumber )

Thanks