Year Sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a crosstab query that looks like this

1994 1995 1996 1997
Task
Person A 3 Hrs 4 Hrs 2.5 Hrs 7 Hr
Person B 6 Hrs 5 Hrs 2 Hrs
Person C 3 Hrs 2 Hrs 6 Hrs 2 Hr
Task
Person A 7 Hrs 2 Hrs 1 Hrs 6 Hr
Person B ...

I have a huge amount of information separated into [EmployeeName], [BillDate], [Task], [BilledHours
I tried to create a crosstab query but as is my billdates are separated into weeks and I receive and error that says I have too many column headers. I am trying to narrow down the dates by creating annual totals for each EmployeeName, but I can't seem to figure out how to do this
Thank you in advance for your help!
 
You might try creating a TOTALS query based on the
Employee by year.
After you have this query built you can create your
CROSSTAB query from the TOTALS query.
Hope this helps.
Good Luck!
-----Original Message-----
I am trying to create a crosstab query that looks like this:

1994 1995 1996 1997
Task 1
Person A 3 Hrs 4 Hrs 2.5 Hrs 7 Hrs
Person B 6 Hrs 5 Hrs 2 Hrs
Person C 3 Hrs 2 Hrs 6 Hrs 2 Hrs
Task 2
Person A 7 Hrs 2 Hrs 1 Hrs 6 Hrs
Person B ....

I have a huge amount of information separated into
Click to expand...
[EmployeeName], [BillDate], [Task], [BilledHours]
I tried to create a crosstab query but as is my billdates
Click to expand...
are separated into weeks and I receive and error that says
I have too many column headers. I am trying to narrow down
the dates by creating annual totals for each EmployeeName,
but I can't seem to figure out how to do this.
 
Back
Top