Can Limit be set for number of rows displayed in subreport

[RBPM]

Good afternoon - Can anyone offer any insight on how to "easily" limit the number of rows displayed in a subreport?

Thanks

 

[hneal98]

You can limit the number by grouping. Without further information as to what you are trying to do, it is hard to say.

 

[dhookom]

Your report's record source can be something like:
SELECT TOP 3 *
FROM tblYourTable
ORDER BY YourField;

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[RBPM]

OK to be a little more specific about what i am trying to accomplish:

* Have a main report that includes several sub reports
* For a sub reports (within the detail section of the main report)I am trying to display just the most recent 5 records based on a number field (its in descending sequence) that is in the related table.
* The source for my sub-form is the related table that can have multiple entries (sequenced by descending number).
* I have a limited amount of space that is available for the subform and that is why I want to restrict the number of records that are displayed lets say 5.

Hope that this is clearer

 

[dhookom]

You can create the subreport controls at their maximum height and set their can grow to no and can shrink to yes.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[RBPM]

thanks for the help - worked like a champ - much appreciated

 

[Mackooo]

Exactly I am also looking for the solution of this problem.

 

[dhookom]

Mackooo,
The solution apparently worked for RBPM. If it didn't work for you, it would be appropriate to describe why it didn't meet yours.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Mackooo]

I got it....

Thanks