How to merge data

R

Russ

I need to merge data from the same fields from 2 separate tables onto 1
column. For example, on 1 table, I have a column that contains test scores
that are linked to a name. On the 2nd table, I have the same column that
contains test scores linked to different names. I want those two columns to
basically update each other so that the missing test scores replace the blank
fields in the other. The problem I am having is that ACCESS places the
information right next to each other, instead of the SAME column. Any
suggestions?
 
K

KARL DEWEY

Post your SQL statement. Open the query in design view, click on menu VIEW -
SQL View, highlight all, copy, and paste in a post.
 
Top