join string and text

[Thedon123]

i have wo sets of data.

C code: 1111 and store code :1121

i wish to join these together automatically in another field so as to give

Place : 1111-1121

how would i do this

cheers

 

[Dembrey]

I believe you should be doing this with a calculated field in a query where the calculated field would be something like:

[New_Query_Field] = [C Code] & " - " & [Store Code]

HTH