Create columns under a heading in Access Report

[jebba]

I've been trying to create a report that shows a customer's order info. The heading lists the customer's name, address, etc. Below the name lists the items in the order. I would like to list the items and quantities in 2 columns instead of one....

Current report looks like this...

Jo
Blo
11 Phillips St.

4 Apples
2 Bananas
1 Broccoli
1 Carrots-Bunch/Loose
1 Grapefruit
1 Greens-Chard
3 Kiwis
1 Lettuce-Green Leaf
5 Oranges
2 Pears
2 Pears-Red
1 Spinach-Loose
3 Squash
1 Tangelos

I would like it to look something like this....

Jo
Blo
11 Phillips St.

4 Apples 5 Oranges
2 Bananas 2 Pears
1 Broccoli 2 Pears-Red
1 Carrots-Bunch/Loose 1 Spinach-Loose
1 Grapefruit 3 Squash
1 Greens-Chard 1 Tangelos
3 Kiwis
1 Lettuce-Green Leaf

I haven't been able to get it formatted correctly.

Appreciate any help.

Thanks

 

[cghoga]

Open the report in design mode.
Go to File - Page Setup.
Click on the Columns tab.
Set the Number of Columns to 2.
Click ok.
Adjust your sections on the report as needed.


Hope this helps you.

 

[jebba]

Thanks,
I've played around with the page setup. But still have problems. The second column starts up top next to the header section. I need to get the food info underneath the address info.

I hope it is a simple formatting issue....

This is what it looks like...

Jo 5 Oranges
Blo 2 Pears
11 Phillips St.

4 Apples
2 Bananas
1 Broccoli
1 Carrots-Bunch/Loose
1 Grapefruit
1 Greens-Chard
3 Kiwis
1 Lettuce-Green Leaf

 

[dhookom]

You can remove all the fruit totals and place them in a multi-column subreport (across then down). Your main report would only contain the address stuff.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.