Print a Report for each record in a table

I have a form based on a table. I can print a report on each record one at
a time.
If I print the report for ALL records, I get one report header and one
report footer.

How can I print reports for ALL records and get a report header/footer on
each record's report?
Right now I would have to select each record and print it.

Hi David

move the information out of the report header & footer into the page header
& footer (if you can't see it its under the view menu)

Cheers
JulieD

"David Peterson" wrote in message
link.net...
I have a form based on a table. I can print a report on each record one
at
a time.
If I print the report for ALL records, I get one report header and one
report footer.

How can I print reports for ALL records and get a report header/footer on
each record's report?
Right now I would have to select each record and print it.

Thanks, Tried that.
There are Report Totals in the header/footer that don't work when I do that.
More suggestions?

"JulieD" wrote in message
...
Hi David

move the information out of the report header & footer into the page
header
& footer (if you can't see it its under the view menu)

Cheers
JulieD

"David Peterson" wrote in message
link.net...
I have a form based on a table. I can print a report on each record one
at
a time.
If I print the report for ALL records, I get one report header and one
report footer.

How can I print reports for ALL records and get a report header/footer
on
each record's report?
Right now I would have to select each record and print it.

Hi David

haven't tested this but what about placing a "sub-report" in the page footer
section that contains the information that you would normally show in the
report footer section (ie create a "totals" query and use that as the source
for the page footer) -do the same for the header section if necessary.

Cheers
JulieD

"David Peterson" wrote in message
link.net...
Thanks, Tried that.
There are Report Totals in the header/footer that don't work when I do
that.
More suggestions?

"JulieD" wrote in message
...
Hi David

move the information out of the report header & footer into the page
header
& footer (if you can't see it its under the view menu)

Cheers
JulieD

"David Peterson" wrote in message
link.net...
I have a form based on a table. I can print a report on each record
one
at
a time.
If I print the report for ALL records, I get one report header and one
report footer.

How can I print reports for ALL records and get a report header/footer
on
each record's report?
Right now I would have to select each record and print it.

David,

Check your expression for report totals. You should be able to write expressions
for totals on the page header and footer to give you totals just for the page.
Julie had the right idea to give you a report for each record.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


"David Peterson" wrote in message
link.net...
Thanks, Tried that.
There are Report Totals in the header/footer that don't work when I do that.
More suggestions?

"JulieD" wrote in message
...
Hi David

move the information out of the report header & footer into the page
header
& footer (if you can't see it its under the view menu)

Cheers
JulieD

"David Peterson" wrote in message
link.net...
I have a form based on a table. I can print a report on each record one
at
a time.
If I print the report for ALL records, I get one report header and one
report footer.

How can I print reports for ALL records and get a report header/footer
on
each record's report?
Right now I would have to select each record and print it.

I tried. Most now work.

Need help getting page number correct.
Should say page 1 of 3, page 2 of 3, page 3 of 3 on each report.
Actually says page 1 of 180, page 2 of 180, page 3 of 180, then next report
says page 4 of 180, page 5 of 180, page 6 of 180 (should say 1 of 3, 2 of 3,
3 of 3 each time)


"David Peterson" wrote in message
link.net...
Thanks, Tried that.
There are Report Totals in the header/footer that don't work when I do
that.
More suggestions?

"JulieD" wrote in message
...
Hi David

move the information out of the report header & footer into the page
header
& footer (if you can't see it its under the view menu)

Cheers
JulieD

"David Peterson" wrote in message
link.net...
I have a form based on a table. I can print a report on each record
one
at
a time.
If I print the report for ALL records, I get one report header and one
report footer.

How can I print reports for ALL records and get a report header/footer
on
each record's report?
Right now I would have to select each record and print it.

a.. Group the report by RecordID
b.. Set the Group's ForceNewPage property to Before Section
c.. In the Group Header Format event, write:
[Page] = 1
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com

"David Peterson" wrote in message
link.net...
I tried. Most now work.

Need help getting page number correct.
Should say page 1 of 3, page 2 of 3, page 3 of 3 on each report.
Actually says page 1 of 180, page 2 of 180, page 3 of 180, then next report
says page 4 of 180, page 5 of 180, page 6 of 180 (should say 1 of 3, 2 of 3,
3 of 3 each time)


"David Peterson" wrote in message
link.net...
Thanks, Tried that.
There are Report Totals in the header/footer that don't work when I do
that.
More suggestions?

"JulieD" wrote in message
...
Hi David

move the information out of the report header & footer into the page
header
& footer (if you can't see it its under the view menu)

Cheers
JulieD

"David Peterson" wrote in message
link.net...
I have a form based on a table. I can print a report on each record
one
at
a time.
If I print the report for ALL records, I get one report header and one
report footer.

How can I print reports for ALL records and get a report header/footer
on
each record's report?
Right now I would have to select each record and print it.

For page numbering, see
http://www.mvps.org/access/reports/rpt0013.htm.
I have used this code successfully.

With the code, everything above Private Sub etc. goes at
the very top of the code window, in the Declarations
section. If you just paste the code I think this will
take care of itself, but I'm not sure.
For group totals, I used a hidden text box in the report
detail with its control source set to the field for which
you need totals, and its Running Sum set to Over Group.
In the group footer I referenced the control.
I have by now lost track of the origin of some of the very
helpful suggestions I have received while learning about
this stuff, but I know that most of them came from this
group. The two previous responders to your post are among
those who have been especially helpful. If I am now in a
position to contribute from time to time, it is due in
large part to this group.
-----Original Message-----
I tried. Most now work.

Need help getting page number correct.
Should say page 1 of 3, page 2 of 3, page 3 of 3 on each
report.
Actually says page 1 of 180, page 2 of 180, page 3 of
180, then next report
says page 4 of 180, page 5 of 180, page 6 of 180 (should
say 1 of 3, 2 of 3,
3 of 3 each time)


"David Peterson" wrote in message
news:7j6Rc.14102
...
Thanks, Tried that.
There are Report Totals in the header/footer that don't
work when I do
that.
More suggestions?

"JulieD" wrote in message
...
Hi David

move the information out of the report header &
footer into the page
header
& footer (if you can't see it its under the view menu)

Cheers
JulieD

"David Peterson" wrote in
message
news:Uz5Rc.14079
...
I have a form based on a table. I can print a
report on each record
one
at
a time.
If I print the report for ALL records, I get one
report header and one
report footer.

How can I print reports for ALL records and get a
report header/footer
on
each record's report?
Right now I would have to select each record and
print it.








.