Filter out max value, but <= today

[ayla]

I have some problems to extract some data from a access database. The problem is that the table hold the entire history of all employees, and I need to extract only the valid value on all employees.

Ex:
Employee1, value1, FromDate: 16.12.2008
Employee1, value2, FromDate: 01.01.2009
Employee1, value3, FromDate: 20.05.2009
Employee1, value4, FromDate: 01.07.2009
Employee2...

If today date is 11.06.2009, then I need to filter out value3 on employee1, because value4 is not valid before july.

Can somebody help me?

[jawadhashmi]

there could be few ways to do this.
1, put the formula in record selection, this will filters the records of your choice.
2, Put the formula on the detail section to suppress the irrelevant records. (not recommended)