Show several values within one query cell

[CW]

Our orders are often each split over several locations while stored in the
warehouse, represented by bay numbers such as A1, C12, H18 etc etc. These
records are held in a table containing the order numbers and locations.

When I run a query to show what goods we have in store and where, the record
is displayed several times (several rows) if it is in multiple locations,
i.e. one occurrence for each different location.

Is there any way to display all the locations for each order all within one
cell (column/row) on the query? I thought about concatenating them in a
non-visible field on the main order form and then pulling them from there,
rather than direct from the locations table. Does anybody have a more elegant
solution?
Many thanks
CW

 

[Duane Hookom]

You could possibly use the generic Concatenate() function found at
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=16.

Duane Hookom
MS Access MVP

 

[CW]

Thanks, Duane, that looks like just what I need!
Many thanks
CW