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