Collapsing records together

[Lisa.Lundergan@gmail.com]

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!

[Roger]

Re: Collapsing records together

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

[Roger]

Re: Collapsing records together

On Jun 26, 7:09 pm, Roger <lesperan...@na tpro.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