ADP vs Report Data Filtering

[DK]

I have an Access 2k adp file connected to SQL 2000. I want to limit the
records in a subreport to the top 3 in descending order by date. The SQL is
easy: SELECT TOP 3 Table.* FROM Table ORDER BY DateField DESC. However, the
OrderBy property is ignored in adp files and Access help says to use the
ServerFilter property to set the sort order. How do you do this? Also, the
TOP 3 must be handled differently because the ORDER BY must be applied
first. How? Any Suggestions would be appreciated.

DJK