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?
Bookmarks