>>That's a simple case. If you would have several max date records, you would have several records.
>>
>>But what if you need to find only one (or few) records with maximum date for each particular group, say, by Town?
>
>If you're searching for 'Nadya' and there are several 'Nadya' you'd get all of them. If you want to search for 'Nadya Nosonovsky' then be more specific and use 'and' to include 'Nosonovsky'.
>Cetin

Here is what I meant:

select town, max(date) as MaxDate from FilingDates group by Town into cursor MaxDates

select * from FilingDates ... ???

We need to select info from the table, where we would have record for each group with MAX date.