<p>I'm making a report in Access 2003 that contains a sub report of related records.  Within the sub report, I want the top two records only.  When I add "TOP 2" to the sub report's query, it seems to select the top two records before it filters on the link fields.  How do I get the top two records of only those records that apply to the corresponding link field?  Thanks.</p>

I've got two suggestions:
1) Pass your master field (on the parent form) to the query as a parameter (you could reference a field on the parent form directly as well)
2) You could fake out rownumbers in Access and limit them to only rownum <= 2. E.g.,
```
```
SELECT o1.order_number, o1.order_date,
    (SELECT COUNT(*) FROM orders AS o2
        WHERE o2.order_date <= o1.order_date) AS RowNum
    FROM
        orders AS o1
    ORDER BY o1.order_date
```
```
(from
http://groups.google.com/group/microsoft.public.access.queries/msg/ec562cbc51f03b6e?pli=1
)
However, this kind of query might return an read only record set, so it might not be appropriated if you needed to do the same thing on a Form instead of a Report.