Creating a summary report from another report

[fiel]

I have a report called TaskSummary, where each page dislpays results for 1 of 12 tasks regarding a summary of total costs and hours per each worker in different subtasks. Is there a way to create a seperate report that would summarize the total costs and hours per each worker for each task as well as summing all totals together from each task into 1 grand total?

 

[dhookom]

Very likely you could do this. We could probably help if we knew something about your table structure, sample data, and desired output with sorting and grouping.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[fiel]

I'm trying for the setup as seen below. As far as my table structure, I have one listing for: StaffNames, HourlyPay, and StaffID. I have a seperate table listing Tasks, SubTasks, StaffID, and HoursWorked.


Task Staff 1 Hours Staff 2 Hours
1 7 5
2 6 8
3 4 4

 

[dhookom]

You are probably requiring a crosstab if you want staff names to display across with hours under the names. There are some sample crosstab report solutions at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]