Putting fields on the first label...

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

Grim Reaper

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


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
 
Back
Top