Combine column data

[adam]

Hi anyone,

How could I write a formula in the query “Contacts Extended”; that would combine the columns “Permanent Address”, “Country” & “City” to the column “Complete Address” so that the data from these three columns would be combined in the following format.

South Land/America. Boston

Any help on this would be kindly appreciated.

Thanks in advance.

[HansV]

Does this do what you want?

Complete Address: [Permanent Address] & "/" & [Country] & ". " & [City]

[adam]

Yeah. It does work. Thanks for he help Hans.