how to combine 3 field into 1 in query

[cysklement]

Hi,

I need help on how to combine 3 field into 1.
For instance. I have a customer table with company name, branch, floor, department. then i am gonna create a query called customerextended and combine all these 3 field so that I can select them in the combobox.

I have a sample here but I just dont know how to edit it...
"Company name: IIf(IsNull([department]),IIf(IsNull([companyname]),[floor],[companyname]),IIf(IsNull([companyname]),[department],[companyname] & " " & [department]))"

Help pls.

 

[cysklement]

Ohh solved:



Company name: IIf(IsNull([department]),IIf(IsNull([companyname]),[floor],[companyname]),IIf(IsNull([companyname]),[department],[companyname] & " " & [department] & " " & [branch] & " " & [floor]))

 

[namliam]

easeir solution:
Trim(NZ(field, "") & " " & NZ(Field2, "") & " " & ... etc)

 

[cysklement]

Oh, just got the code fix a bit to work according to what i want

Original:"Company name: IIf(IsNull([department]),IIf(IsNull([companyname]),[floor],[companyname]),IIf(IsNull([companyname]),[department],[companyname] & " " & [department]))"

edited: "Company name: IIf(IsNull([companyname]),[department],[companyname] & " " & [department])"

 

[cysklement]

how to mark it solved?