Hi,
I know im not going to explain this correctly the first time, but here I go...
I have a report that has 6 fields that can happen six times each with an effective date.
looks like
1 2 3 4 5 6
-------------------------------------------
#of cues 3 | 4 | 5 | 6 | 7 |8
------------------------------------------
# of att 7 | 8 | 9 |10| 2 | 4
---------------------------------------------
etc .. for 4 more fields each set 6 * 6 has the same date associated with it
so the above table is for 10/1/11
I want to display a report with days of the month 1 thru 31 across
so day1 would have
#of cues (1) =3
#of att(1) = 7
# of cues (2) = 4
# of att(2) = 8
etc...
any ideas or examples would be great
Thx
Joe