Prev: Case statement Problem not resolved Still
Next: Vertically Aligning Fields in a Sub-Report
From: Syphonics via AccessMonster.com on 5 Jul 2008 09:56
Is it possible to have the order details to be listed horizontally which is
seperated by a comma after each value instead of the default vertical listed.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200807/1

From: Marshall Barton on 5 Jul 2008 11:29
Syphonics via AccessMonster.com wrote:

>Is it possible to have the order details to be listed horizontally which is
>seperated by a comma after each value instead of the default vertical listed.


You can use Duane's generic Concatenate function to do that:

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: Case statement Problem not resolved Still
Next: Vertically Aligning Fields in a Sub-Report