I have two columns, both text, returned from a query. In MS Query I double click one of them and I can see how its pulled out:

My Live Data$Accounting Period.Period Name

and the other is:

My Live Data$Accounting Period.No_

I need to merge the two of them into a 3rd column that is the two strings added together. I cant figure how to do this and ive tried:

[My Live Data$Accounting Period.Period Name]&[My Live Data$Accounting Period.No_]

[My Live Data$Accounting Period].[Period Name]&[My Live Data$Accounting Period].[No_]

And Ive tried the same things using + instead of &.

What am I missing?