I am trying to create a report that shows how much time a particular employee spent not on a certain job, but on a certain work code.
For example,
Name: Joe Blow
Worked: x amount of hours
Doing: Bidding And Contract Negotiations.
Worked: x amount of hours
Doing: Code Research
Etc...
I'm pulling the data from two tables:
1. tblemployee
2. tbltimesegments
tbltimesegments has a field called "workcodes" and a field called "elapsedtime". I want to summarize this elapsed time for everytime the workcode field changes. But when I use the wizard to create the report, it won't let me add a grouping level for the field, workcode.
If I could just group by this field, then the summary stuff would be no problem. Any suggestions?
For example,
Name: Joe Blow
Worked: x amount of hours
Doing: Bidding And Contract Negotiations.
Worked: x amount of hours
Doing: Code Research
Etc...
I'm pulling the data from two tables:
1. tblemployee
2. tbltimesegments
tbltimesegments has a field called "workcodes" and a field called "elapsedtime". I want to summarize this elapsed time for everytime the workcode field changes. But when I use the wizard to create the report, it won't let me add a grouping level for the field, workcode.
If I could just group by this field, then the summary stuff would be no problem. Any suggestions?
