I have managed to get my concatenated text to work combining 2 fields into 1. Now my problem is how do I get them all to show up? It's deleting duplicates even though I changed the properties for unique values and show all records. What I have is:

SELECT [tblCABLES].[SIDE A SPACE] & [tblCABLES].[SIDE B SPACE] AS Spaces, *
FROM tblCABLES;


My end result should be all of SIDE A SPACE and all of SIDE B SPACE.

I also tried doing a Union query, but ended up with the same results.

Thank God for this board. You guys have saved my butt so many times!

Thanks!