Hi, I need a help about how to get the last record (of each group) in a query , something like this:

Select field1,
field2,
max(mydatefield3)
group by
field1 ,
field2

I´m obtaining some records of each group, but I need just ONE record (determined by : max(mydatefield3)).

How can I do that?

Thanks in advance
Carlos Burgos