subreport in detail line..sortable?

[Guest]

I have master/child tables of Nurse and Specialties. Report shows nurse
details, and
put a subreport on each detail line to concatenate 1 to x specialties for
each nurse.

Is possible to sort the details on main report, by that subreport's text box?

(tried putting qualified textbox from subreport into Grouping/Sorting
expression, but says did not find)

thx!

 

[Allen Browne]

In order to sort the main report by a field in the subreport, you must get
that field into the RecordSource of the main report.

Use a query as the main report's RecordSource.
The query will contain both tables (Nurse and Specialities.)
In query design, depress the Total button on the toolbar.
Access adds a Total row to the grid.
Group By the fields from the main table, and choose the appropriate grouping
(Count? Sum?) on the field from the Specialities table that you want to sort
by.

Once you set the report's RecordSource property to the name of this query,
you will have the field to sort by in the main report.

 

[Guest]

Thanks Allen - I added join with other query (that used concat function to
concat child records), and got into report recordsource.

Thanks again!