Printing a Report

  • Thread starter Thread starter Chris B
  • Start date Start date
C

Chris B

I am trying to find a way to print only the first 5
records of a report with code inside of the report.

Any ideas?

Thanks

Chris
 
If you have an autonumber field as the PK in the table, the autonumber field
will be in ascending order of when the records were added to the table. Take
this princilpe and create a query containing the autonumber field and all the
other fields you want in the report. Sort ascending on the autonumber field.
Right click in the upper part of the query window and click on properties. Set
the Top property to 5. This will give you the first five records returned by the
query and since the PK is sorted ascending will give you the first five records
that were entered in the table.
 
Back
Top