Tough Columnization Question

  • Thread starter Thread starter Bufo Calvin
  • Start date Start date
B

Bufo Calvin

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!
 
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.
 
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
 
Back
Top