statsman
Active member
- Local time
- Yesterday, 19:14
- Joined
- Aug 22, 2004
- Messages
- 2,088
I am using Access07
I have a report from a query that looks like this:
Player1
Week1: 2
Week2: 2
Week3: 4
Total: 8
Player2
Week1: 0
Week2: 3
Week3: 2
Total: 5
What I would like is a report that looks like this:
Player..........Week1..........Week2..........Week3..........Total
Player1...........2..................2................4.................8
Player2...........0..................3................2.................5
Is this somthing I can do with the report design or do I have to go back and tweak my query?
Please be specific in advice, I am entering a new area here.
I have a report from a query that looks like this:
Player1
Week1: 2
Week2: 2
Week3: 4
Total: 8
Player2
Week1: 0
Week2: 3
Week3: 2
Total: 5
What I would like is a report that looks like this:
Player..........Week1..........Week2..........Week3..........Total
Player1...........2..................2................4.................8
Player2...........0..................3................2.................5
Is this somthing I can do with the report design or do I have to go back and tweak my query?
Please be specific in advice, I am entering a new area here.