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

Putting fields on the first label...

P: n/a
I asked this question, earlier, and received an answer that I am not sure
about how to do.

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?

In the report header, there are 3 fields that I want to 'separate' into
another label: 2 label fields and a count field of one of the other fields.
I am running the report off a query that INNER JOINS 2 tables. I am pulling
5 fields from one table and 7 fields from another table. It was suggested
that I use a Union Query (Create a separate query, then, write a Union Query
on the original query and the newly created query that would produce the
first label, separated from the rest. In the newly created query, it was
suggested that I use a pseudo-field in order for the Union Query to use as a
sort to put the 'new' label at the beginning.

I am not sure how to do this, but, I did not try, with no success, though.

I hope I explained it correctly. If not, do not hestitate to ask me to
explain something.

Thanks for any help,
Grim Reaper
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Grim Reaper wrote:
I asked this question, earlier, and received an answer that I am not sure
about how to do.

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?

In the report header, there are 3 fields that I want to 'separate' into
another label: 2 label fields and a count field of one of the other fields.
I am running the report off a query that INNER JOINS 2 tables. I am pulling
5 fields from one table and 7 fields from another table. It was suggested
that I use a Union Query (Create a separate query, then, write a Union Query
on the original query and the newly created query that would produce the
first label, separated from the rest. In the newly created query, it was
suggested that I use a pseudo-field in order for the Union Query to use as a
sort to put the 'new' label at the beginning.

I am not sure how to do this, but, I did not try, with no success, though.

I hope I explained it correctly. If not, do not hestitate to ask me to
explain something.

Thanks for any help,
Grim Reaper

I think a far easier way for you do this would be to put your data in
the report FOOTER rather than header, you might lose a label or two but
if it doesnt matter it will spare you the headaches :)

Good Luck
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.