If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I want to compare fields from two files
I want to reconcile fields from two different sources that have the same
field names. Both files have the following fields that I plan to import to separate tables: Social Security number Last Name First Name Loan ID Disbursement ID Disbursement Sequence Number How do I assign a key to these tables once I import them when the only thing that distinguishes on record from another is a combination of the Loan ID, disbursement ID and Sequence Number? |
#2
|
|||
|
|||
I want to compare fields from two files
I think I know the answer to my own question. I need to designate all fields
that make the records unique as the primary key - and then do an unmatched query. "Patty Stoddard" wrote: I want to reconcile fields from two different sources that have the same field names. Both files have the following fields that I plan to import to separate tables: Social Security number Last Name First Name Loan ID Disbursement ID Disbursement Sequence Number How do I assign a key to these tables once I import them when the only thing that distinguishes on record from another is a combination of the Loan ID, disbursement ID and Sequence Number? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
compare fields | alavaz17 | Running & Setting Up Queries | 4 | June 15th, 2005 05:21 PM |
Whether Word can compare the content of two word files? | PerduBug | General Discussion | 1 | June 3rd, 2005 03:32 PM |
Compare fields in query | ds | Running & Setting Up Queries | 4 | October 1st, 2004 12:00 AM |
Product Key for Office XP | P.G.Indiana | Setup, Installing & Configuration | 1 | June 7th, 2004 03:22 AM |
Compare multiple fields in record | Can | Running & Setting Up Queries | 1 | May 29th, 2004 04:27 AM |