List Type Report

[grubnz]

I am creating a report in Access 2010.
What I want to achieve is that the information that is printed is to stay on one page so I would like to make two columns. Is this possible?

I used this query first but it didn't seem to work.
FullName:[LastName]&", "&[FirstName]--[Phone]--[Handicap]--2/3H/C:Round([Handicap]*2/3)

Next query this did work but there is now no formating

List:[FullName]&" "&[Phone]&" "&[Handicap]&" "&Round([Handicap]*2/3)

I have attached a word document to show what I mean as it was difficult to show here.

Thank you for your assistance if anyone could help with this.

 

[JHB]

From the Internet - seach words "report+ms-access+2 column"

When you preview the report after the Report Wizard finishes, you'll see that Access produced a single column report, which is the default. To change the report so that it uses multiple columns, click Page Setup on the File menu, click the Columns tab, and type the number of columns you want in the Number of Columns box. Make sure your report is selected in the Database window (or displayed in the Print Preview window) before you open the Page Setup dialog box. The changes you make to the settings in the Page Setup dialog box apply only to the currently selected report, and not to other existing reports or reports you may create later.

Column settings you can change in the three sections of the Page Setup dialog box:
Grid Settings section

• Number of columns Enter the number of columns per page.
• Row Spacing If additional space is desired between each detail record, enter the amount of space here.
• Column Spacing Enter the amount of space you want between columns.

Column Size section

• Width Enter the width of each column.

Keep in mind the margin settings and column spacing when setting this value.

• Height Enter the height of one row in the column.
• Same as Detail Check this to set the column width and height equal to the width and height of the Detail section.

Column Layout section

• Down, then Across Check this when you want records to print down the first column, then down the second column, and so on. Columns run across the page.

Choose this layout for a snaking-column, or newspaper-style column effect.

• Across, then Down Check this when you want records to print across the first row, then across the second row, and so on. Rows run from the top of the page to the bottom.

 

[grubnz]

HI JHB I would like to say thank you for your assistance and time. It worked!
Have a Merry Christmas and a Happy New Year.

 

[JHB]

You're welcome - also Merry Christmas and a Happy New Year to you.