Shoutbox

I am trying to build a query in my MS Access database.  I am operating on Office 2000.  I have 2 tables that I am working with.  Both tables contain columns with identical information.  These identical fields are currently linked together as a subdatasheet under tables.  What I would like to do is create a query where, if the data from one table is identical to data in another table, then values are copied and pasted in to the main table.

Here is what I am talking about:

I have 2 tables:
1 = ISMCompany
2 = BPIncCompany

Both tables contain the identical fields "DepartmentName."  I am trying to bring data from table 2 over to table 1 and paste information from table 2 in the columns if the "DepartmentName" fields in both tables are identical.  I would think this would be a simple task:

Create an append query and append data to table 1 where the criteria is as follows:

"If [ISMCompany]![DepartmentName] = [BPIncCompany]![DepartmentName]"

I am pulling my hair out and have been trying to figure this out for over 12 hours now.  Someone, please please help!  It seems like it would be a simple problem to fix, but I just can't figure it out and I am going crazy!