Report Header in Mailing Labels...

I know this is probably an easy question, but I could not find/figure it
out.

Basically, I am printing mailing labels with a "Sorting/Grouping" section
that groups the label types together. Also, I am using a "Report Header" to
show a count of how many total labels that are being printed.

Now, my problem is that without the "Report Header", the spacing is perfect.
But, when I add the Report Header, it gets shifted downwards and the last
row of labels gets printed on the next page (the last row of the first page
is blank).

I am trying to figure out how to use the first label as the Report Header
and let the next label print at the top of the page. Is there a way that I
can group the Report Header and make it only print on the first label so
that the labels will print at the top of the page?

I hope I explained it correctly. If not, do not hestitate to ask me to
explain something. I have not been able to figure this out, and have just
lived with it, but now I would like to fix it.

Thanks for any help,
Grim Reaper

Grim Reaper wrote:

I know this is probably an easy question, but I could not find/figure it
out.

Basically, I am printing mailing labels with a "Sorting/Grouping" section
that groups the label types together. Also, I am using a "Report Header" to
show a count of how many total labels that are being printed.

Now, my problem is that without the "Report Header", the spacing is perfect.
But, when I add the Report Header, it gets shifted downwards and the last
row of labels gets printed on the next page (the last row of the first page
is blank).

I am trying to figure out how to use the first label as the Report Header
and let the next label print at the top of the page. Is there a way that I
can group the Report Header and make it only print on the first label so
that the labels will print at the top of the page?

I hope I explained it correctly. If not, do not hestitate to ask me to
explain something. I have not been able to figure this out, and have just
lived with it, but now I would like to fix it.

Thanks for any help,
Grim Reaper


Why not put that in the footer?

Create a new query that contains the fields you want in the first label and be
sure you have the same number of fields that are in your label. You also need a
pseudo field that corresponds to the field you are sorting and grouping on. The
pseudo field needs to be in the same order in your query as the sorting and
grouping field is in the recordsource of your report label. Also the value of
the pseudo field needs to come before the first value of the field you are
sorting and grouping on. Say the first value of your sorting and grouping on is
"Avalarez" (last name). You can make the pseudo field come before this with the
expression:
PseudoField:"AA" in your query.
After you have done all of the above, create a union query between the current
record source of your label report and the new query you created. Change the
record source of your label report to the union query and keep the same sorting
and grouping. In your union query, the data from the new query you created
(which is the data you want in the first label) will print on the first label
because you set
PseudoField:"AA" in your query.

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

www.pcdatasheet.com


"Grim Reaper" wrote in message
...
I know this is probably an easy question, but I could not find/figure it
out.

Basically, I am printing mailing labels with a "Sorting/Grouping" section
that groups the label types together. Also, I am using a "Report Header" to
show a count of how many total labels that are being printed.

Now, my problem is that without the "Report Header", the spacing is perfect.
But, when I add the Report Header, it gets shifted downwards and the last
row of labels gets printed on the next page (the last row of the first page
is blank).

I am trying to figure out how to use the first label as the Report Header
and let the next label print at the top of the page. Is there a way that I
can group the Report Header and make it only print on the first label so
that the labels will print at the top of the page?

I hope I explained it correctly. If not, do not hestitate to ask me to
explain something. I have not been able to figure this out, and have just
lived with it, but now I would like to fix it.

Thanks for any help,
Grim Reaper