I have a query (crosstab) that has week beginning dates in the first
column then Monday - Friday in the following columns. The values are
names of assignments. It is set up like a 5-day calendar and I have
this pulling into a re****t. I am wanting to know if there is a way to
collapse the records together to have all the assignments under the
same week collapse together so I don't have separate lines for each
assignment. Any suggestions would be greatly appreciated! Thanks!
