I've been trying for awhile to acquire the correct information and have not been successful. I will start with the basics and I am hoping you all will be able to help!
I have 6 fields in my table:
[SO] Service Orders
[RepName] Last name of engineer
[DateofServ] Date
[TimelogReason] 4 options (Labor,Network)- which is billable...(PreSales,NoBill) which are nonbillable
[LogHours] Hours used
[LogMinutes] Minutes used.
In my report I have to Group by Last name of the engineer and report from the timelogs how many total hours he had for the week that were billable and how many were nonbillable.
Example:
Smith
12-12-16 Labor 4.5 hours
12-12-16 Presales 3.5 hours
12-13-16 Network 2 hours
12-13-16 NoBill 1 hour
12-13-16 Presales 5 hours
Total Nonbillable Time - 9.5 hours
Total Billable Time - 6.5 hours
I can get everything to display in my report correctly with a query and by Grouping on [RepName]. However, I am having issues totalling on Billable and Nonbillable time in my footer.
Can you help my with a an iif statement that will accomplish this?
I appreciate any help you can give me.
Thank you!