record to record comparison?

[eao]

I am trying to write a report to display recurring Work Orders:

(Group by Subject, Client)

1. count (WO#) > 1, and
2. Datediff (OpenDate)less than or equal to x days of each other.

I can't figure out how to compare the OpenDate of multiple records. I thought about using the Select formula to set the date range, but I don't think that will work. I want to be able to run this report for the past six months, and return those records for a Client with the same subject if they were opened within 10 days of each other.

Advice? Thanks.

 

[synapsevampire]

Based on this:

"I want to be able to run this report for the past six months, and return those records for a Client with the same subject if they were opened within 10 days of each other. "

Try the NEXT() function to suppress rows NOT of interest (place in the details suppress formula):

datediff("d",next({MyTable.OpenDate}),{MyTable.OpenDate}) > 10
and
{MyTable.Subject} = next({MyTable.Subject})
and
{MyTable.Client} = next({MyTable.Client})

Something like that should do it...

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[eao]

Close, but Next only compares consecutive records?

 

[synapsevampire]

Right, so sort accordingly.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com