I am really struggling with one element within a report.

I have a series of records and what I am trying to do is set a variable if ANY of the records meet a condition. This issue I have is it works if the most recent record meets the condition but the variable (I guess the clue is in the name) changes if the next record does not meet the condition.

For example

Record 1 No - Date 01/01/17
Record 2 No - Date 04/03/17
Record 3 No - Date 11/02/17
Record 4 Yes - Date 01/03/17
Record 5 No - Date 12/03/17
Record 6 No - Date 09/01/17

The report is grouped so the records above are in a sub group of a supplier.

In this example the report returns the date 09/01/17 and I am trying to get it to return Record 4 Yes - Date 01/03/17.

I use the If record = "No" but this only works if "No" is TRUE for the last record in the cycle. It cycles on to the last record so the final return changes as the condition is no longer met.

Any ideas or advice would be very much appreciated.

Kind regards,

Iain.

Edited by idavis - 16 Mar 2017 at 8:47pm

I am trying to use 01/03/17 as the date something starts in a time calculation.

Record 4 Yes - Date 01/03/17

The issue I have is the variable pages through and changed to Record 6 No - Date 09/01/17.

Kind regards,

Iain.