Concatenating 3 Felds

[Dody]

Hello
I am creating a query by concatenating 3 fields first one is a lookup text and others are number and lookup. For a reason 1st field (lookup) it does not show any value when running the query only Flied 2 and 3 are showing.
E.g.
TowerNo: lookup
RoomNo: Number
RoomType: lookup
I write SQL:
SELECT [TowerNo] & [RoomNo] & [RoomType] AS RoomAdd
FROM Table1;
I get result:
RoomNo+ RoomType
TowerNo Field Value is missing ..!!!?
If I query for TowerNo filed alone it show up perfectly..!!?
Any Idea how to fix my problem I am using Access 2007

Thank you

[Rainlover]

Use a Query to create this then use the SQL String as required.

[Dody]

Use a Query to create this then use the SQL String as required.

Thank you for your help..I did use a Query but it seems that the lookup field is now working with me if I add it on the 1st of the concatenation...