I have two tables.
Example: (Table A and B have identical field names)
Table A has 5 records with 5 fields with data in only 3 of the fields.

Table B has identical 5 records plus 5 additional records, and has data in all fields.

How would I go about combining the two tables into Table A, adding the additional records from table B to Table A, plus adding in the missing data for the (5) common records of from B to A?

Thanks for the help!
Terry

The answer is here http://www.access-programmers.co.uk/ubb/Forum3/HTML/002325.html

with your other question.