I spen the last hour delving into the book ACCESS 2003 Bible but for the life of me I can't figure it our.
I have two simply tables.
A matching number field, ie., 448-342-98 in both tables.
I want to add ALL of the records form a smaller table to the large table. I KNOW FOR A FACT that the above field with the number will not have a duplicate record in either table.
Any ideas . . . Rick
I have two simply tables.
A matching number field, ie., 448-342-98 in both tables.
I want to add ALL of the records form a smaller table to the large table. I KNOW FOR A FACT that the above field with the number will not have a duplicate record in either table.
Any ideas . . . Rick