2. ASPRunnerPro General questions
  3. layout for combined table fields in a query.
This topic is locked

layout for combined table fields in a query.

 		11/20/2007 16:45:59
ASPRunnerPro General questions
M
 mfred author

I have a project which needs to combine specific table fields into 1 field. I wrote a querie in Access with the following expression:

DeliveryInformation: ([Company]+", "+[Contact]+", "+[Address]+", "+[City]+", "+[State]+", "+[ZIP]+", "+[Phone])
Is there a way that I can have returns so that the resultant display in the list is:

Company

Contact

Address

City, State, ZIP

Phone Number
A
 		alang 11/20/2007

One way would be to use the Concat SQL function on the SQL page to create a new field. ie:
SELECT ..
CONCAT(`Company`,', ',`Contact`,', ',`Address` ... ) AS DeliveryInformation,
etc.
M
 		mfred author 11/26/2007

I am unsure about what Concat SQL function is.