Multi-Column & Row Report

[AuditorCMM]

We have a database where employees enter the time spent each day on a
particular project. A report is needed to show the total time each employee
spent on each project. For example

John Mary Dave
Project #1 10 5 20
Project #2 15 10 10
etc...

What would be the easiest way to set up a query to summarize the data in
this manner?

Thanks!

 

[John W. Vinson]

What would be the easiest way to set up a query to summarize the data in
this manner?

The Crosstab wizard in the new query window.

John W. Vinson [MVP]

 

[AuditorCMM]

OK. I set up a crosstab query with the project as the row headings and the
staff as the column headings. Now, how would I set it up to only be for a
particular time period? In other queries I've done, I've set the criteria
for the date field to be Between [Beginning Date:] and [Ending Date:]. Would
i be able to include a date field in the query somehow so that I can choose
the date range, but not have the dates actually show up in the query?

 

[AuditorCMM]

By the way, I did try to add a column to the query based on the Date field in
the table and then put in the criteria I'm used to, but I kept getting error
messages. Help!

OK. I set up a crosstab query with the project as the row headings and the
staff as the column headings. Now, how would I set it up to only be for a
particular time period? In other queries I've done, I've set the criteria
for the date field to be Between [Beginning Date:] and [Ending Date:]. Would
i be able to include a date field in the query somehow so that I can choose
the date range, but not have the dates actually show up in the query?

The Crosstab wizard in the new query window.

John W. Vinson [MVP]

 

[John W. Vinson]

By the way, I did try to add a column to the query based on the Date field in
the table and then put in the criteria I'm used to, but I kept getting error
messages. Help!

Please open the query in SQL view and post it here, and tell us what the error
message was. We can't see your screen!

John W. Vinson [MVP]