Concatenate Sub Query?

[JohnR]

Is it possible to run a subquery that has multiple records and concatenate
them into a single string for use in athe main query?

I have an order with multiple order details. I want to build a string out
of the multiple details to include them as a single field in my main query.
Can it be done? And if yes, How?

Thank you in advance for your assistance.

John

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

 

[Micah Chaney]

Yes -- And it is so useful for other things.
Say you have a [Field A] with value "Mr." a [Field B] with value "Michael"
and a [Field C] with value "Jones"...
You would create a separate field like this:

Name: [Field A]&" "&[Field B]&" "&[Field C]

This will yield: Mr. Michael Jones

The "&" concatenates fields and text surrounded by "".

You don't need to do this in a sub query either...Hope this helps.