Jet Report question

I need to figure out how to filter the Employee Rate table Amount field so that the only figure that is returned is the most recent Rate. We keep history of all rates that an employee has had so we have several lines per employee in many cases. Can the filter be on the Date or the Amount? thanks for any help. I am just beginning to use Jet Reports. If this is the wrong place to post this question, I appologize.