I'm attempting to develop a report which will bring back an employee's most recent hearing test record.
The data could look something like :
Employee A : 19/5/97
19/5/99
19/5/01
Employee B : 4/4/98
4/4/00
4/4/02
In this instance, I would only want to retrive the data associated with the 19/5/02 test (Emp A) and 4/4/02 test (Emp B)
Is there some formula I can write in the select expert that will automatically check all date records and return the correct data.
Any help would be most appreciated
The data could look something like :
Employee A : 19/5/97
19/5/99
19/5/01
Employee B : 4/4/98
4/4/00
4/4/02
In this instance, I would only want to retrive the data associated with the 19/5/02 test (Emp A) and 4/4/02 test (Emp B)
Is there some formula I can write in the select expert that will automatically check all date records and return the correct data.
Any help would be most appreciated