Limit Records on a Report

[sandylt]

Is there a way to limit the amount of records on a subreport. Sometimes I have more that 25 lines, however the records past 25 might be repeated for duplicate orders. I only want to display the first 25 and anything beyond that not show.

 

[ThreeCrow]

Will take it for granted, that you Report or subReport is base on a Query. If it is not, then you will need to make it so.

With the Query open in design view, look at the top of the screen, you will see the word "All" with down ward arrow on the right side. Left click on the arrow. The list will drop down, if none of the numbers are to your liken, type a number in.


Hope this helps

 

[sandylt]

Although it is based on a query, that wont work for me. If I set the query to 25 it only show 25 records throughout. I need 25 records per day. I can do it on a form, but It will not let me do it on a report. I need the first 25 records for each day.

 

[ThreeCrow]

Try this site,


http://support.microsoft.com/default.aspx?scid=kb;en-us;210350&Product=acc