Field Merge

J

Jim

Is there a way to take a field from 3 different tables and merge it into 1
field in a new table? The field(s) is/are titled "PART" and although the part
numbers are different in each table, the format is the same.
 
P

PhilT via AccessMonster.com

Jim

If this is a time only, you could merge them with Excel, and import back to
Access. However, if this is a continuous to the future, I think you should
create a relationship among the tables. Good luck.
 
Top