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]

Re: Report in Table Format?

"Techpriest " <techpriest@our lair.com> wrote in
news:1125435764 .661426.50400@g 49g2000cwa.goog legroups.com:
[color=blue]
> 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!
>[/color]
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.