Hide/Limit Records in a Report

G

Guest

Hi, I have a subreport that contain upto 63 records. However I can only fit
32 lines on a singe page and then the remainder goes onto the next page. I
want the report to stay on a singe side, therefore I want to limit one report
to 32 records and then display the remaining records on another report. I
have created a count field within the report, however how do I prevent one
report showing records after number 32 and the other only showing records
after 32.

Any help would be grately appreciated. Tahnks
 
A

Allen Browne

Create 2 queries to feed the 2 reports.
In query design view, open the properties box.
Set the Top Values property to 32 for one query, and 31 for the other.

You will need to sort these queries in opposite ways. For example, if you
sort on a field named ID, the first will need to be Ascending, and the seond
query Descending.

(On the reports, you can sort them any way you wish. This is just for
selecting the TOP records.)
 

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

counting records shown in a report 3
Limit Records Shown Per Report 5
A03 - count in report footer gives me #Error? 0
ability to limit records printed to 5 on a sub report (within areport) 1
Hide reords in a report 1
Report with fixe number of records 1
Subreport messing up spacing of report 4
Sub report not displaying all data 1

Top