Printing a Report

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
 
P

PC Datasheet

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top