Hi there,
This is what I am trying to do:
Create a query that will insert a column from Table 2 into Table 1. These two tables are exactly the same in structure, however, there is no unique identifier in either table. For example, Table 1 has fields called Broker Number, Category, and Total Amount, and Table 2 also has fields called Broker Number, Category, and Total Amount. Broker Number and Category are identical in both tables, however, Table 1 has a higher Total Amount than Table 2. I need to be able to insert the Total Amount field from Table 2 into Table 1. Table 1 has 9000 records in total, while Table 2 has 7000.
If anyone can help me out - much appreciated!
Thanks,
Leigh