Compare 2 columns if match insert data from 3rd col into new col

  • Thread starter Thread starter Guest
  • Start date Start date
From your terse description, it sounds like you are trying to store a
calculated value. If so, don't (it is rarely necessary in a well-normalized
relational database).

If you provide more (specific) information, the 'group readers may be able
to offer more (specific) suggestions...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
 
I have two Excel files. In both they have a column called Enterprise No.
One file also has a field called FSE. What I want to do is add the FSE data
to the file that did not contain it originally, matching the Enterprise #.
 
Is this an Access question (Microsoft Access, relational database)?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP
Microsoft IT Academy Program Mentor
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel 2007 Like or Contains Expression 2
Emulate XOR in Access 5
Macro for comparing columns and highlighting matching/differences 14
Compare data set 1 with data set 2. Add to data set 2 if not found 0
Help! Forgot formula for copying cell value if condition is met 1
Find largest value in column with 2 criteria 1
inserting values into new columns while importing from textfiles 3

Back
Top