Hi All,
I'm trying to create what I'm calling a "summarized report" in access 2016, but without luck. I've been searching for posts on creating the report described below, but I haven't found anything. Perhaps I'm incorrectly referring to this as a summarized, or grouped report?
Basically, I have a time sheet table with a new record for every time work was perform for a customer on a project. I'd like to generate a report which summarizes all of the hours for work completed on a specific service item for customer, and then have all the service descriptions listed below the total. See the example below.
CUSTOMER 1Project 1
1/1/2016
Service Item 1____[space]____Total Hours for This Item (ex: 1.25)
Description 1
Description 2
Description 3
Description 4
Service Item 2____[space]____Total Hours for This Item (ex: 2.5)
Description 1
Description 2
Service Item 3____[space]____Total Hours for This Item (ex: 5.75)
Description 1
Description 2
Description 3
1/2/2016
Service Item 1____[space]____Total Hours for This Item (ex: 3.25)
Description 1
Description 2
1/6/2016
Service Item 1____[space]____Total Hours for This Item (ex: 1)
Description 1
Description 2
Service Item 2____[space]____Total Hours for This Item (ex: 2)
Description 1
Description 2
Description 3
Service Item 3____[space]____Total Hours for This Item (ex: 3.5)
Description 1
Description 2
Description 3
Project 2..., etc.
CUSTOMER 2
Project 1..., etc.
The Time Sheet table where the data originates contains the following fields, and all fields are completed for each record.
Customer:
Project:
Date:
Service Item:
Hours:
Description:
Can anyone point me in the right direction re how to create this report. I'm faily new to access, but have a lot of experience with excel and a pretty good concept of database interaction.
Thanks for the suggestions,
David