Field Concatenation in a single table
- From: Mr. Beginner <mrbeginner@xxxxxxxxxxxxxxxxxx>
- Date: Wed, 10 Sep 2008 08:55:02 -0700
I have imported 160,000 records from an Excel file into an Access table
called "Vendor Master". The Vendor Master table has 3 fields, all text, that
I would like to combine into 1 field to be used as a key field.
I created a new field called "VIN" to combine the 3 other fields, but can't
seem to get the expression right......... if in fact I should be even using
an expression?
GIVEN INFO: Database Name - CSU
Table Name - Vendor Master
Field#1 Name - PRE
Field#2 Name - FEID
Field#3 Name - EXT
My failed expression in default value: =[Vendor Master]![PRE]&+[Vendor
Master]![FEID]&+[Vendor Master]![EXT]
I keep getting an error message saying that Access can't find my field
names? Where did I go wrong?
HELP! HELP! HELP! HELP!
.
- Follow-Ups:
- Re: Field Concatenation in a single table
- From: John W . Vinson
- Re: Field Concatenation in a single table
- From: tcsteele
- RE: Field Concatenation in a single table
- From: KARL DEWEY
- Re: Field Concatenation in a single table
- Prev by Date: Help creating a database
- Next by Date: Drop down boxes
- Previous by thread: Help creating a database
- Next by thread: RE: Field Concatenation in a single table
- Index(es):