Ok this time i have given up on Pivoting a table so i have come up with an idea!


i have the table set out how i want it.

It looks like....

Type May June July August Etc.....

Trip 0

Slip 1

RTA 2

now i have 11 other tables holding the months that are not on the one above

i am going to loop throught the dataset tables and add the rows to the above table so it will look like this


Type May June July August Etc.....

Trip 0 11 12 4 6

Slip 1 0 5 3 9

RTA 2 20 45 12 15


is this easy to do???


i have started using a For Each but i have now come to a stop as i'm don't know how it needs to work and if it will work


i thought i could just get the column to equal the month like

with dsReport.Tables("Report").rows(counter)

.Item(counter) = drrow.item(counter)

End with

will this work????