I want to use a report to make an alphabetical two-column list of items in a table that do not have a Yes/No box ticked. I used a query, which sorts these items alphabetically.
The report also works well. However, it will list like this:
Apples Biscuits
Cheese Doughnuts
Whereas I want it to list alphabetically down the left hand column, then when it gets to the end of the column, continue in the right hand column (just as would happen when you use 2 columns in Word). e.g.
Apples Cheese
Biscuits Doughnuts
How do I achieve this?
Many thanks in advance
The report also works well. However, it will list like this:
Apples Biscuits
Cheese Doughnuts
Whereas I want it to list alphabetically down the left hand column, then when it gets to the end of the column, continue in the right hand column (just as would happen when you use 2 columns in Word). e.g.
Apples Cheese
Biscuits Doughnuts
How do I achieve this?
Many thanks in advance