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

 

[llkhoutx]

Use the NZ on each field concantenated. A Null field concantenated will destroy the whole concantenated result.

 

[Dody]

Use the NZ on each field concantenated. A Null field concantenated will destroy the whole concantenated result.

Thank you for your help, but it did not work..Anyone get idea on the data type of a field and the relation with other tables might have some restriction or limitation and need some of modification on the properties to enable the concatenation
Thank

 

[llkhoutx]

Try

...([TowerNo] & [RoomNo] & [RoomType] AS RoomAdd)...