Hey, what's up? Cheers from a newbie.

Does anyone know if it's possible to sort/group a report's data, first, by a field on the main report, and, second, by a field on a subreport?

I have two tables (tblQualifications, tblSENLIST) represented in one report (tblSENLIST as a subreport). The subreport shows employee data from tblSENLIST such as Employee Name, Date of Hire, Seniority Ranking, etc..., the main report shows data from tblQualifications regarding each Employee's Qualifications. tblQualifications' primary key is Employee Name, and its source is the same field of tblSENLIST.

What I need to do is group the information on the main report by, Yes, a person is qualified, or, No, a person is not qualified (recorded in a tblQualifications checkbox), then sort each group by each employee's seniority ranking on the subreport (from tblSENLIST). Is this possible?

Using the Sorting and Grouping command, I can group the main report into two groups: Yes, someone is qualified, or, No, someone is not qualified for a certain job. I can also open the subreport and sort by Seniority Ranking using the Sorting and Grouping command (when I preview the subreport, it's always sorted correctly). However, when I preview the main report, it is only arranged by the sorting applied to the main report (groups of Yes, then groups of No), and the subreport's data seems to be arranged randomly.

Any help would be great.

Thanks,

David

Hi:
I'm not sure that you need a subreport.
Create a query that has both tables. Link them by Emp Number or
anthing that would create the proper link.

Within the query sort by Yes/No (Ascending would put yes first) and
then by seniority.

Now you can use the grouping on the single query and it should be
fine.

Good luck.

Ira Solomon

On Thu, 17 Aug 2006 07:11:23 -0500, sprouldc
<sprouldc.2coqhz (AT) no-mx (DOT) forums.yourdomain.com.au> wrote:

Thanks, Ira. It worked like a charm. You pretty much rock the access house. I tried that before, but never knew to link the tables, so the query builder would always be hatin. Thanks again.