Grouping and sorting

[Lanason]

I want to group records by a field but sort the groups by a record WITHIN the group.

The example is that I wish to group the interviews I have had by the company and then sort these by the most recent individual interview so that the most recent Group for the same company is at the top.

hope that makes sence ??? any ideas

 

[Uncle Gizmo]

How would you do it with a query?

Just thought! Can't you group by Comapany, then sort on date decending?

 

[Lanason]

mmmm

probably expalins why I could work not it out.

Not sure how to do it within Queries Unless I can create a new field that is used both for grouping and sorting and add this to each record.

That gives me a thought - not very elegant but

 

[Thecherub]

Try a Subreport

probably expalins why I could work not it out.

Not sure how to do it within Queries Unless I can create a new field that is used both for grouping and sorting and add this to each record.

That gives me a thought - not very elegant but

The main report would be the Company and in the subreport you would list the Interviews for each company and sort them however you want.