Joining two fields

[Neil.Cranston]

I want to join to fields in a query. I am using access 97. I just want to be able to pick up two fields from the query, create a new column and display the details together. the code I am using to create the column is

Switch&Port:[switch]&"-"&[port]

when i try and run the query i get an error saying that i have not used brackets correctly.

any one got any suggestions, or is this sort of operation not allowed.

Neil Cranston

 

[charityg]

Don't use an ampersand (&) in the field name

so

Switch_Port:[switch]&"-"&[port]

Try that and see how it works
Charity