2 columns on report

[banny04]

Hi,



I should start out by saying I normally develop in Java but my manager ask me to create an Access application for tracking equipment. So this might be a dumb question. My problem is with a report. I am bringing a query back that shows all of the equipment given to an employee. However the user wants the list to be in two columns side by side and I am not sure how to do this in Access.

So kind of whats below,


Equipment Assigned To banny04

result1 | result2
result3 | result4


and so on.


Any help would be appreciated.

PS I am also working with Access 07

[June7]

You might set the report up as two-column. I have done this to get output like:

Result1 | Result 10
Result2 | Result 11
Result3 | Result 12
Result4 | Result 13
Result5 | Result 14
Result6 | Result 15
Result7 | Result 16
Result8 | Result 17
Result9 | Result 18

You might be able to get what you want with a column setting for Across, then Down.

If that doesn't work use VBA code. Check this:
http://allenbrowne.com/func-concat.html

[banny04]

Yea that work after I posted this I just starting going around to all the different properities and settings to try and find anything that would help and eventually found the column settings you mettioned after about an hour more or so. Like I said a dumb question but Thanks.