Hide/Limit Records in a Report

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

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.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Steve Hughes" wrote in message
...
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

I was under the impression that reports in Access ignored the MAX records property from a query?

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

From postings
http://www.developerfood.com/hide-li...a/article.aspx
Michael wrote in message ...
I was under the impression that reports in Access ignored the MAX records
property from a query?

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com