By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,853 Members | 918 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,853 IT Pros & Developers. It's quick & easy.

Report Header in Mailing Labels...

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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?

Nov 13 '05 #2

P: n/a
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
re******@pcdatasheet.com
www.pcdatasheet.com
"Grim Reaper" <gr*****@nospam.com> wrote in message
news:f4********************@comcast.com...
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

Nov 13 '05 #3

P: n/a
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

"PC Datasheet" <no****@nospam.spam> wrote in message
news:Uq******************@newsread3.news.atl.earth link.net...
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
re******@pcdatasheet.com
www.pcdatasheet.com
"Grim Reaper" <gr*****@nospam.com> wrote in message
news:f4********************@comcast.com...
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


Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.