This topic is locked

combining 4 columns of similar data into 1

4/10/2008 6:13:10 PM
ASPRunnerPro General questions
M
mfred author

I have a project using Access. I used ASPRunner for developing the front end. It's a jobs submission module. People are able to submit up to 4 jobs at once. All works well but I need to create a query where the 4 columns of job names are merged into 1 column list. In other words, column a, b, c & d are all text fields and I need them all listed in a new column in a query. I hope that makes sense. I know this is not specifically an ASPRunner question but rather an Access question. But I will be using ASPRunner to view the querry and thought that someone may be able to give some directions. Thanks in advance.

J
Jane 4/11/2008

Hi,
edit your SQL query on the Edit SQL query tab.

Here is a sample:

select

a + ' ' + b + ' ' + c + ' ' + d as [abcd],

fieldname1,

fieldname2,

...

from TableName

P
paulyap2k 5/6/2008

if there is a pontential null value in any of the fields to be combined, I have tried this to avoid new field becoming a null value.
SELECT

field1&' '&field2&' '&field3 AS field4,

FROM TableName