On Jun 26, 7:09*pm, Roger <lesperan...@natpro.comwrote:
On Jun 26, 2:57*pm, Lisa.Lunder...@gmail.com wrote:
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 report. *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!
assuming the 'letters' are 'assigments', is this the query's result
* * * mon tue wed thu fri
16 * * *a * b * * c * *d * e
23 * * * * * f * * * * * *g
30 * * * * * * * * *h
if so, what do you want it to look like
if not,, what does it currently look like
so if your current query output is
The query results look like this:
mon tue wed thu fri
16 a
16 b
16 c
16 d
16 e
16 f
23 g
23 h
30 i
and you would like it to look as I mentioned above
what is the rule that defines that 'a' on the first row of date '16'
and 'f' is on the second row ? that's assuming that 'a' and 'f' cannot
be on the same row