Query/Report with x/y axis and sums

[robbeh]

I am trying to create a query/report to display totals of two criteria's for each location.

We have three locations we capture data for. Site1/Site2/Site3. When also capture if an employee is Fulltime, Temp Fulltime, Part Time and Temp Parttime and their department. I am trying to create a report that totals how many of each status we have of employees in specific departments.

The report requests from the user what Site they want to report on. The report I am looking for looks like:

Reporting on: Site1

Fulltime Temp Fulltime Part Time Temp Parttime
I.T. 23 5 16 2
PR 10 7 10 0
...etc

I really am lost where to start here. Is their a name for this type of reporting? Maybe this is easier than I think.

Thanks!

[NTC]

well instead of x/y you may mean cross tab; but save that for later as that is just presentation format... the key is establishing the counts.... the way to do that depends on the structure of your data; assuming your table is something like this: Name, ID, Department, F/P, Temp

then you first want to focus on an Aggregate query that will result in the correct counts

the report presentation would be a second step