different records on one line

[airtabaki]

I have a simple database where I store all the adresses of all the people I know. Now I want to send a letter to all those people and I want to make a report that creates the adress labels on my envelop. Therefor I use special paper, but it's a bit expensive. So I want to print more adress labels on one line.
Is it possible to print more records on one line, and is there a simple way to do that?

 

[hymn]

If you go into page setup of the report and alter the column setting to two you will be able to print two records per line and if you have the space you could change it to three.
dont forget to move everthing to the left as pos in design view

Hope this helps
Hymn

 

[Volk359]

If you're looking for mailing labels like Avery try importing the Cutomer Labels report from the sample Northwind Traders database and change the table/query names.