By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,190 Members | 1,412 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,190 IT Pros & Developers. It's quick & easy.

Collapsing records together

P: n/a
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!
Jun 27 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Jun 27 '08 #2

P: n/a
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
Jun 30 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.