Table Update Not Updating...

[drmingle]

I want to create a new table in MS Access 2007, based on 2 other tables.

Table A has all the data.

However, where table A and table B have the same value (specifically field12), I want to replace that value with the number "2".

I thought the criteria would be something like:

=IIf([Numerics In The Train Data But Not The Test Data].[Resource],1,[Azn_Train].[Resource])

It is asking for parameter values....

I want to bump up against the other table, not have to enter each by hand.

Thanks in advance.