Report in Table Format?

[Techpriest]

I have an Access 2000 database that keeps track of Employee Training.
I have a table with employees and a table with classes. I have a form
that will let me pick a class, then it will show me who took the class
and the date they took it. I have a form that will let me pick an
employee, and see all the classes they took, and the date they took it.

I have a query that has all this data.

I want a report that has the employee names down the left, the class
names across the top and where they meet, the date the class was
attended.

If there is a name for that kind of report I would appreciate knowing
it so I have a place to start looking. Thanks!

[Bob Quintal]

"Techpriest" <te********@ourlair.com> wrote in
news:11*********************@g49g2000cwa.googlegro ups.com:

I have an Access 2000 database that keeps track of Employee
Training. I have a table with employees and a table with
classes. I have a form that will let me pick a class, then it
will show me who took the class and the date they took it. I
have a form that will let me pick an employee, and see all the
classes they took, and the date they took it.

I have a query that has all this data.

I want a report that has the employee names down the left, the
class names across the top and where they meet, the date the
class was attended.

If there is a name for that kind of report I would appreciate
knowing it so I have a place to start looking. Thanks!

What you want is a report based on a CrossTab query of your
existing query.

--
Bob Quintal

PA is y I've altered my email address.