Combining multiple fields into one colomn

[KeithB14]

Hello,

I have a table with employee numbers in four fields (Leader, Facilitator, ect...). How can I combine those numbers into one column trough a query?

Thanks in advance.

Keith

 

[boblarson]

Concatenation:

Create a column in a query by something like:
MyData:YourFieldNameHere & " " & YourNextFieldNameHere & ", " & YourThirdFieldNameHere

That would give you the first field with a space between it and the second and then a comma and space between the second and third. This was for an example only and you will have to put your own field names in and whatever you want between them. Do not use the example as written.