concatenating two vendor codes

[pat67]

My company recently changed the vendor codes and now I end up with two
separate sets of data for each vendor. Obviously I could just leave
the vendor code field out. I don't want to do that so what I need to
do is concatenate the two codes. Example

Vendor Code Vendor Name
123 Joe's Supplies
ABC Joe's Supplies

what I need is this

Vendor Code Vendor Name
123/ABC Joe's Supplies

any ideas?

 

[Lynn Trapp]

Rather than create a new record for each vendor, add another field to the
table -- call it NewVendorCode -- and put the new value in that. Then, in a
query you can concatenate them as:

FullVendorCode: [VendorCode] & "/" & [NewVendorCode]

 

[pat67]

Rather than create a new record for each vendor, add another field to the
table -- call it NewVendorCode -- and put the new value in that. Then, ina
query you can concatenate them as:

FullVendorCode: [VendorCode] & "/" & [NewVendorCode]

--
Lynn Trapp
MCP, MOS, MCAS

My company recently changed the vendor codes and now I end up with two
separate sets of data for each vendor. Obviously I could just leave
the vendor code field out. I don't want to do that so what I need to
do is concatenate the two codes. Example

Vendor Code    Vendor Name
123                    Joe's Supplies
ABC                  Joe's Supplies

what I need is this

Vendor Code     Vendor Name
123/ABC             Joe's Supplies

any ideas?
.- Hide quoted text -

- Show quoted text -

I can't really do it that way since the table is updated from another
file that only has one code. What I did was create a table based off
of the original table and then concatenated. Then joined that query to
any other query i needed. I was just seeing if there was a way to do
it without an extra table