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