Access & concatenating

  • Thread starter Thread starter craig nock
  • Start date Start date
C

craig nock

I have a text file, supplied from outside, that I need to
use to create a Access Table. The problem is the file has
the Product info split across 3 fields - I want to combine
into 1. I have loaded the file into a temp table, how do I
combine the fields to create a 'new' product key?
Thanks
 
Craig,

make a query on the temp table and use a calculated field like:

ProductKey: [Field1] & "_" & [Field2] & "_" & [Field3]

where Field1-3 are the names of the three fields, change as appropriate.

HTH,
Nikos
 
Hi,



SELECT f1 & f2 & f3
FROM myTable



concatenates fields f1, f2 and f3.

Hoping it may help,
Vanderghast, Access MVP
 
Back
Top