Query in which I am trying to match records from one table toanother, based on Two Fields

M

Mike C

I am somewhat new to access and would like to know how best to
approach the following query.

I have two tables.

The one table (Table A) has ID numbers and Social Security numbers
(i.e., both fields have been completed) for each record.

In the other table (Table B), each record may have one, or both of
those identifers (i.e., perhaps a social, perhaps an ID number, and
perhaps both).

Can you please let me know how you would recommend that I proceed to
produce a list showing all patients that
 
D

default105

Proper structuring to 3 normal form should be followed. Therefore you should
not have duplicate data in your database but rather linked by primary/foreign
key relationship. If you have duplicate data you will not be able to
retrieve accurate results.
 

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

MATCH DATA IN SEVERAL DIFFERENT FIELDS FROM TWO TABLES 1
Update Data in one table based on matching field in another table 4
Query to list records that don't match 6
Two fields to one record 1
Combine data in two records from same field 16
Pull multiple records from one table to another? 2
sorting on two fields together 1
Query that seeks to match all records b/w two tables by either SocialSec # or Name 5

Top