SubTable records limited in report and forms

G

Gravey

I have a table of items and a sub table of purchasing history. When i
print a report I want to limit the purchasing history to say 4 of the
latest dates and ordered by date. The same for forms.
 
A

Allen Browne

The simplest way to do this would be to use a subreport (or subform). Use a
query that asks for the top 4 records, i.e.:
SELECT TOP 4 * FROM MyTable;
 
Top