How to merge data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Post your SQL statement. Open the query in design view, click on menu VIEW -
SQL View, highlight all, copy, and paste in a post.
 
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

Database structure 3
Linking tables from existing data 1
Excel Applying Code to a Column 0
Max 2
Trying to update multiple fields in the same record (same table) 2
Creating a Sum Column on a Table 10
Employee Evaluations 3
VBA - retrieve data on last create named range from previous inserted named range 0

Back
Top