Query to insert field from one table into another table - no unique identifier

[lcourchesne]

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

[NeoPa]

So, you want to update (rather than insert) the [Total Amount] field in [Table 1] when, and only when, there is a record in [Table 2] whose [Broker Number] & [Category] fields match those in the record from [Table 1], with the value of [Table 2]'s [total Amount] field?