Collapsing records together
in [Help]
|
Prev: Checkboxes and Shadowing, Unshadowing, Highlighting
Next: Crosstab used in Graphing Incidents per Day and per Week for a Month
From: Lisa.Lundergan on 26 Jun 2008 16:57 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!
From: Roger on 26 Jun 2008 21:09 On Jun 26, 2:57 pm, Lisa.Lunder...(a)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
From: Roger on 30 Jun 2008 11:51
On Jun 26, 7:09 pm, Roger <lesperan...(a)natpro.com> wrote: > On Jun 26, 2:57 pm, Lisa.Lunder...(a)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 |