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.
 
You must log in or register to reply here.

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

Similar Threads

Print report based on form selection 1
report to PDF format 5
Print report based on form selection 2
Access Access Report Works on One Machine but not Another 3
Repost:Use runcommand acCmdPrint to print a report 1
recording the print date 3
Time Delay to Print Report 2
Pass Subform filter to subform in report 0

Back
Top