Concatenating 3 Felds

Dody

Registered User.
Local time
Today, 16:38
Joined
Feb 17, 2010
Messages
10
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
progress.gif
 
Use the NZ on each field concantenated. A Null field concantenated will destroy the whole concantenated result.
 
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
 
Try
PHP:
...([TowerNo] & [RoomNo] & [RoomType] AS RoomAdd)...
 

Users who are viewing this thread

Back
Top Bottom