sorting a subreport field

[cooldisk2005]

All,
I have a report that has subreports.

If I wanted to sort the main report by a field from one of the subreports, how could this be done?

Again, any help would be appreciated.

Thanks in advance,
Jerome

 

[dhookom]

You would need to add the field from the subreport to the record source of the main report. This can usually be done without much difficulty.

If you can't figure out how to do this, you will need to come back with more information about your record sources.

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]