I still see what you want as a crosstab query. The only difference, as you
say very well, is that you want to pivot on the "date type" values and not
the ID values.
The only other thing you need to decide in order to make a crosstab report
is "what information goes in the position for the row
Hi - I've read the threads about converting rows of data into columns,
but those threads assume the number of distinct rows is very limited
(say 7 for days of week).
Instead, I have a table like this:
iddate date type
1 ... a
1 ... b
2 a
2 d