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