Constant number of lines per group - Access 2007

[bcbrock]

I need to print a constant number of lines per group, as my report
needs to print on pre-printed forms, and the data needs to land in the
correct location on the paper.

I found the following support article on Microsoft's web site, but it
indicates that it works only through version 97. Hoping it would
still work anyway, I followed the instructions, but it did not work
for me in Access 2007.

http://support.microsoft.com/kb/q119073

Does anybody know how to accomplish this in 2007?

TIA.

 

[Jeff Boyce]

"... did not work ... in Access 2007" does not tell us much.

Did Access print anything? Did nothing happen? Did your PC catch fire?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[bcbrock]

My apologies....

My results were the same as if I had not followed any of the
prescribed steps outlined in the KB article.

For each group, Access 2007 printed 1 line of data per record found -
no more.

Thanks.

 

[Jeff Boyce]

Is it printing only the "first" record found "for each group", or the last,
or some apparently random record?

In your report, what are you grouping on?

Does your report have both a Group By band and a Details band? The GroupBy
would be where your group ID/title/whatever shows, but the Detail band
beneath it would be where all the detail records show.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[bcbrock]

The data in my report comes from 2 tables: ASTU & AIMM. I have a 1-
to-many relationship established between the two tables. ASTU contains
(among other fields) "LastName", "FirstName", and "Permnum". Permum
is a student ID number, and so is unique in the ASTU table.

I am grouping on a concatonation of "LastName, FirstName PermNum".

My report does have both a group header band, and a details band.

When the report runs, it will print the student name and ID number (as
per the concatonated field), and prints each related record (in the
details section) from the second table, AIMM, which are immunization
records.

I am not having difficulty with it ommitting information - all my data
is there. The challenge I'm trying to overcome is getting access to
print 10 lines of data (or 10 detail sections) per student, regardless
of how many immunization records are found in AIMM. For example, if
student "Joe Smith" has 4 immunization records, I want Access to print
those 4 records (which it is currently doing just fine), followed by 6
blank lines.

The URL I posted above shows how to accomplish this on previous
versions of Access, but following those steps in 2007 does not produce
the blank lines I'm looking for.

Thanks.

 

[Jeff Boyce]

Rather than debug a KB article, I'd probably suggest searching on-line for
something like "MS Access Report print constant number of lines" ...
(without the quotes or ellipses)

Regards

Jeff Boyce
Microsoft Office/Access MVP