Categorize in a Report

[AccessQuestions]

This one of those long winded questions, he it goes:

Have a table that holds records of appointments. There are several types of
appointments that are for different departments. Admin, HR, Sales,
Development, etc. I would like them to be placed in a report like the
following, basically setup in columns:

Admin | HR | Sales | Development | Other

To add a little complexity I would like to have the following stats for each
department to the left:

# Appointment each department at beginning of period
Number of new appointments
Number of appointments transferred
Number of closed appointments
Total appointments YDT

So it would look like

Admin | HR | Sales | Development | Other
# Appointment dpt BOP # # # #
#
Number of new appointments # # # #
#
Number of appointments transferred # # #
#
Number of closed appointments # # #
#
Total appointments YDT # #
# #

There will be other stats based on the departments that I want to pull from
this table into this report as well.

What would the best way of doing this be?

 

[Rich]

Try creating a crosstab query then a report with the crosstab as its
source