create a report the gives a breakdown of a sum

[pvoegele]

I use a Access database at work to track work hours by billing code. However, I need to have a report that displays a break down of hours worked by each code. The following is a sampling of how the report displays data and the total of hours:

EMPLOYEE NAME DATE WORKED CODE TOTAL HOURS WORKED
JEFF M. 4/11/2013 C1 8.00
DOUGLAS S. 4/11/2013 C1 9.50
KAREN A. 4/11/2013 C1 4.00
TOM K. 4/11/2013 C2 6.00


TOM K. 4/11/2013 C1 2.00
ADAM L. 4/11/2013 C2 3.00
ADAM L. 4/11/2013 C1 5.50
TOTAL HOURS WORKED: 38.00

I would like it to do the following when it displays the total:

TOTAL HOURS WORKED: 38.00
TOTALS HOURS WORKED BY CODE:
C1= 29.00
C2= 9.00

Is this possible to have a sum calculation to only total when another field equals a certain value or is it possible to have it automatically to give a breakdown?

Thank you!!!

[pbaldy]

Create a new query based on that table. Add the code and hours fields to the grid. Click on the totals icon on the ribbon (looks like a Greek E). In the new row displayed, change group by to sum on the hours field. Run the query.

[June7]

Do you want report to show the individual employee info? Consider instead of aggregate sums in query, build report using Grouping & Sorting feature with aggregate calcs in group footer textboxes.

[pvoegele]

Do you want report to show the individual employee info? Consider instead of aggregate sums in query, build report using Grouping & Sorting feature with aggregate calcs in group footer textboxes.

I just want to have individual totals of each work code.

[June7]

Then you can do aggregate query or use the report structure to calc aggregates. Make the report Detail section not visible and the individual info won't display. This is basic Access functionality and Access Help has guidelines on both.