Selective Subform by record number (1 Viewer)

[Harry Taylor]

Please Help.

I have a DB with 1000+Records.
Each record has a "History" field showing the date I last visited (about 20+Visits each).
When I re-visit I print Report (A4 size) which gives me the address and previous visits, however I only want my report to show the last 6 visits.

I have tried both a Query & Subform and changed the "Top Values" from ALL to 6, but this only gives the last 6 visits from all records.
I need to see the last 6 visits for each record.

Can anyone help?

 

[billmeye]

You could use Grouping in your report to show the detail based on whatever you consider a record and base the reports record source on your top 6 query.