Is there a simple way to list the names in a report horizontalinstead of vertical?Example – current
Larry
Stan
Jim
Would like
Larry Stan Jim
Thanks
Brad
Is there a simple way to list the names in a report horizontalinstead of vertical?Example – current
Larry
Stan
Jim
Would like
Larry Stan Jim
Thanks
Brad
In the property of the box
OTHER tab
vertical = YES
HOWEVER, they only flip 1 way. Usu the wrong vertical way you want them .
If CROSSTAB query cannot do what you want, review http://allenbrowne.com/func-concat.html
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.