Query Sort

  • Thread starter Thread starter Scooter
  • Start date Start date
S

Scooter

I have a query [DepCummOutputTotal] that returns the following data:

Week Drafter Output With Grade
1 Drew Walters 13
2 Drew Walters 26
3 Drew Walters 47
4 Drew Walters 60
5 Drew Walters 68
1 Robert Keys 13
2 Robert Keys 25
3 Robert Keys 42
4 Robert Keys 55
5 Robert Keys 73
1 Tom Bankston 17
2 Tom Bankston 30
3 Tom Bankston 45
4 Tom Bankston 60
5 Tom Bankston 75

This is a cummulative total for each Drafter for each week as the year
goes by. I need another query [DepCummOutputFinal] that will return
the following data using the values from the query above:

Week Drew Walters Robert Keys Tom Bankston
1 13 13 17
2 26 25 30
3 47 42 45
4 60 55 60
5 68 73 75

The Week will go from 1 to 52.

Any suggestions on how to accomplish this?

And, here's another problem to throw into the mix; the number of
Drafters depends on a checkbox on a form. In this case, only three
were chosen (there could be from 1 to 7 Drafters picked from the
checkboxes).

Thanks in advance.
 
This can be created using a Crosstab query with Week as the Row Heading,
Drafter as the Column Heading and Output... as the Value.
 
Back
Top