Thedon123 Registered User. Local time Today, 17:03 Joined Sep 11, 2002 Messages 98 Sep 18, 2002 #1 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
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
D Dembrey Registered User. Local time Today, 18:03 Joined Mar 6, 2002 Messages 65 Sep 18, 2002 #2 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
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
