How do you make an address list with two columns??

[jmpWashDC]

Hi,
I am trying to make a Report address list from an existing query. I tried to repeat the design from a very similar report by copying the boxes and fields while in the design window and pasting them into the new report.
It doesn't look quite the same.
The old report has two columns of data arranged vertically under the header, 8 addresses per page, no header on the second page, 10 addresses per page.
The copied version resulted in only one column of data with only two addresses per page.

I basically want the report to look like Mailing labels with a header on the first page only.

I'm pretty new to Access report "design"
Isn't there some way I can see the code of the existing report that I want to emulate?
Otherwise I don't think I can do it.
Thanks
JMP

 

[CosmoKramer]

JMP,

Did you try using the Label Wizard to create the label report and then insert a report header in design view?? That should work.....

 

[jmpWashDC]

I just tried it....
It doesn't work for my data...
I need 9-10 lines per address...
"address" also includes Job title, Company, Country, Phone, Fax, email address
thanks...

 

[CosmoKramer]

It still should work, there are many sizes of labels to choose from......

 

[jmpWashDC]

I think the limit is 8 lines per label.
When the label wizard prompts:
"What would you like on your mailing label...",
The Prototype label: window only allows 8 total lines.
We use 2" x 4" labels (2 columns of 5, 10 per page).
I know that fits 9-10 lines of text.

I even tried making a custom sized label...
3" x 4"
that didn't work either...

Can you think of any other way to get a report to ouput groups of addresses in two columns??

 

[jimmythegeek]

Just make your own label report.

1. Create a report with the header you want in either the report of page header.
2. In the details section create what looks like a label with all the info you want on it. It should take up less than half of the horizontal space on the page.
3. Go to File | Page Setup | columns, and change the number of columns to 2.
4. Mess around with the column settings until you get it to print the way you want it to. Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?

 

[jmpWashDC]

I've done some editing and it's close enough to what I want
so now I need the answer to this question:
How do I tell the LabelReportMarch2002 to look at QRYMarch2002 instead of QRYApril2002 like it's doing now....
eeeek!
jmp

 

[CosmoKramer]

In the report's properties, change the Record Source to the query that you want. You should be able to select it from the drop-down.....