Printing order

rbuser

I have a query that is generating multiple records for the same student
id. Every record has the following info:
student d, Last name, First Name, Class
I am ordering the query by student Id and then in the report I create a
group that breaks on the student Id field. This works really good
except that I need the print order to be by the student name instead of
the student id. I can not order the query by Student name since I have
to break the group on student Id (unique per student).

Any suggestion or help would be greatly appreciate.
Thanks in advance.
Nina.

digitalmetaphors

In the query, order by ID, then LastName. Your result set will be ordered
so that you get the groups of ID's together, and then the last names will be
ordered inside of the ID groups.

Cheers,

Jim Bennett
Digital Metaphors

rbuser

Thanks for the reply but this won't work for me. I think I
didn't explain my
self well.
Example of what I get now is:

Id Name Classes
1 Smith
Engl
Math
2 Anderson
Music
P.E.
3 Mitchell
Social

What I actually need is:

2 Anderson
Music
P.E.
3 Mitchell
Social
1 Smith
Engl
Math

I still need to order the query by Id so that I get the
right classes per id.
I appreciate the help.
Nina.

digitalmetaphors

I don't think you can order by ID and have the records print ID's in the
order 2, 3, 1.

What if we think of this table as two tables: classes and students. You
should be able to contrive a master-detail configuration based on your one
table, using two queries. The master will retrieve the different ID's. Then
the detail query will return the ordered names for those ID's.


Cheers,

Jim Bennett
Digital Metaphors