compare current record field to next record field

[BelindaNiles]

Hello -

I need to write a formula which will compare the EndTime in the current record to the StartTime of the next record. If there are any gaps or overlaps in time, I need to flag that line in the report.
I've tried a few different formula scenarios, but to no avail.
Any suggestions are welcomed and appreciated.
Thank you,
BelindaNiles

 

[synapsevampire]

Try a formula with:

if {MyTable.Endtime} <> next({startime}) then
&quot;Doesn't Match!!!&quot;

Or just enter:

{MyTable.Endtime} = next({startime})

into the suppress formula for the detail and you'll only get those that don't match.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com