Re: Tough Columnization Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Bufo Calvin (anonymous_at_discussions.microsoft.com)
Date: 04/02/04 

Date: Fri, 2 Apr 2004 11:47:20 -0800

You can see the problem from a single table:

Program User Status
English Jane First
Math Jane Repeat
English Joe First
Science Joe First
Math Lily Repeat
Math Raul First

They would want this to look like this on a single page:

ENGLISH

FIRST 2 REPEAT 0

MATH

FIRST 1 REPEAT 2

and so on.

The problem that I have is that, when I tell it to break
to the second column for status, that also seems to force
a page break. If it breaks to the second column for
FIRST, I think it also breaks to a new column after
REPEAT, which puts it on the next page.

Any assistance would be appreciated.

FIRST

>-----Original Message-----
>I would expect you to provide some indication of the
table structure(s),
>field names, and sample data.
>This can probably be answered very easily with a totals
query.
>
>--
>Duane Hookom
>MS Access MVP
>
>
>"Bufo Calvin" <anonymous@discussions.microsoft.com>
wrote in message
>news:129a101c41846$119f5ad0$a001280a@phx.gbl...
>> This came from one of my students. He needs to group
by
>> a category, and then wants to columns to indicate a
count
>> by, we'll say, Active and Inactive. I can get columns
>> going, but not for this effect:
>>
>> ENGLISH
>>
>> Active 17 Inactive 3
>>
>> MATH
>>
>> Active 15 Inactive 5
>>
>> and so on. On the same page, a page-width band for the
>> group header, then two columns for the detail of that
>> group, then a page-width band for the next group
header,
>> then two columns for the detail of the next group, and
>> going on.
>>
>> Any help would be appreciated!
>
>
>.
>

Relevant Pages

  • Re: FellKnight goes Pro
    ... If the word came from repeat, ... Let's face it -- English is a crazy language. ... English muffins weren't invented in England or French fries in France. ... creativity of the human race. ...
    (rec.gambling.poker)
  • Re: Whats that?
    ... "What's that" is a request to repeat more clearly. ... this is not an English usage problem. ... for the listener to make a best guess at what was said and to repeat ... This works well substantively because many non-native English ...
    (alt.usage.english)
  • Re: Unwanted page break
    ... Let's forget the group footer idea. ... itself in the outer group header with no white space. ... repeat section on the inner header. ... Dim blnBreak As Boolean ...
    (microsoft.public.access.reports)
  • Re: Skipping a line by condition
    ... Good morning Gina. ... I'm sorry I did not see any Group Header for Repeat ... Add a Group Footer for the PositionTitle, space it about half an inch. ...
    (microsoft.public.access.reports)
  • Re: Repeat Section property causes Access 97 to hang
    ... I set the Repeat Section property for a report Group header to yes. ... One field in the table is a memo field. ...
    (microsoft.public.access.reports)