Crosstab Query Question

  • Thread starter Thread starter Jill
  • Start date Start date
J

Jill

This post is based of something I posted on September
22 "Query Names and Entries" . I am trying to work on a
database where I have a table of all the employees and a
table of reviews done on their work. Each employee has
some many reviews done by their manager and so many done
by corporate. I am trying to query the the reviews agaist
the employee list to show the dates of all reviews for a
person and also show whether the review was by the manager
or corporate.

I tried the suggestion of a crosstab query with employees
in the row and dates in the columns. But I have run into
the problem that the list becomes to large to read easily
if I break the reviews into calendar date and when I group
by month I can not account for whether the reviewer was
corporate or a manager.

I still have a lot to learn about Access and really
appreciate any help.

Thanks!
 
Try adding the ReviewerField as a Row Heading (Total = Group by)

The records in the Crosstab will increase to the number of Reviewers (5
Reviewers = EmployeeName x 5) so you will have to build a report to see the
data neatly.

Cameo
 
Back
Top