Records Before and After

[Niet32]

Is there a way to look at the information for a record just before and after?

For example: If all the records have a time included and I want to know if the record before and after are within 30 minutes of the current record. Is there a way to autmotically flag and report those records?

[comment]

Create a self-join based on:

YourTable::SerialID > YourTable 2::SerialID

Sort the relationship by SerialID, descending.

Define a calculation field =

Timefield <= YourTable 2::Timefield + 1800

This will return 1 if previous record's time is within 30 minutes of the current record, 0 otherwise.

If there's a chance of crossing midnight, use:

Timefield >= YourTable 2::Timefield and Timefield <= YourTable 2::Timefield + 1800

or

Timefield < YourTable 2::Timefield and Timefield <= YourTable 2::Timefield - Time ( 23 ; 30 ; 0 )

Edited July 25, 2005 by Guest