Report Header in Mailing Labels...

  • Thread starter Thread starter Grim Reaper
  • Start date Start date
G

Grim Reaper

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 said:
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
Click to expand...

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.
 
I am a little confused. I have not had much experience with Union Queries. I
have only used one off of one database to concatenate a few fields into one
field.

I have tried to do as you suggested, but I must have done something wrong.

Okay, the query that I am using right now to run the report off of is an
INNER JOIN on 2 tables. It is pulling 5 fields from one table (BRO_CODE1,
BROCODE2, BRO_CODE3, BRO_CODE4, and BRO_CODE5 - these are used to separate
the mailing labels into different categories). It is also pulling 7 fields
from another table (NAME, ADDR1, ADDR2, CITY, STATE, ZIP_CODE, and COUNTRY).
The query uses 12 different fields to create the mailing labels. They could
be using one or all of the Bro_Codes to separate the mailing labels. Also,
the 2 tables are joined on an ID number (INQ_ID).

In the Report Header of the mailing labels, I am only printing 3 separate
items: (1) A label that names the 'report', (2) a label that just says
TOTAL, and then (3) right beside the word total is a count of the INQ_ID
(this is so that I can get a count of ALL of the labels that are being
printed).

What I would like to do is to put the 3 separate items on the first label,
by itself, so that it will not throw off the spacing at the top of the
labels for the whole first sheet of labels.

(I could not even get the PseudoField to work correctly). I tried to create
a separate query that only included the count of the INQ_ID field (didn't
work). Also, I tried to use the same query and added all of the fields to
it. Then, do a Union Query on both of the queries (didn't work).

Please help, (thanks),
Grim Reaper
 
Back
Top