update query

[kstyles]

Okay - I've got my update query to work with the following sql:



UPDATE [Annual Review Table] INNER JOIN [Loan Table] ON ([Annual Review Table].Borrower = [Loan Table].Borrower) AND ([Annual Review Table].Borrower = [Loan Table].Borrower) SET [Loan Table].[Relationship Manager] = [Annual Review Table].[Relationship Manager], [Loan Table].Branch = [Annual Review Table].[Branch], [Loan Table].Borrower = [Annual Review Table].[Borrower]
WHERE ((([Loan Table].[Annual Review Number])=[Annual Review Table].[Annual Review Number]));


It updates all the records I HAD in my table - but it's not updating the new records I have entered.... Each time I run it it says I'm updating 38 rows - which was my pre-existing data. I have added 6 more rows that need updating. Is there something I'm missing so that I can update everything?

[weekend00]

based on my guessing (only guessing because not enough information to make sure), you should join on [Annual Review Number] instead of [Borrower]:

UPDATE [Annual Review Table] INNER JOIN [Loan Table] ON [Loan Table].[Annual Review Number])=[Annual Review Table].[Annual Review Number] SET [Loan Table].[Relationship Manager] = [Annual Review Table].[Relationship Manager], [Loan Table].Branch = [Annual Review Table].[Branch], [Loan Table].Borrower = [Annual Review Table].[Borrower]

[kstyles]

I input the new records in a subform. When I input them it is just a loan number and a dollar amount, and an annual review number. Then when I am done I want to run a query to update the blank portions of their specific table - a borrower, a relationship manager, and a branch.

The new records only have a loan number, loan amount, and an annual review number. This is the same way I had all the other records before I ran the update query.

The corresponding table that it's supposed to update from has everything in it - ie the borrower, relationship manager, branch...

[weekend00]

I've edited my post, did you notice that?

[kstyles]

Thank you for your help. It makes more sense now! I was way off there. Anyway - here's my final SQL if anyone every needs a reference:

UPDATE [Annual Review Table] INNER JOIN [Loan Table] ON ([Annual Review Table].[Annual Review Number]=[Loan Table].[Annual Review Number]) SET [Loan Table].[Relationship Manager] = [Annual Review Table].[Relationship Manager], [Loan Table].Branch = [Annual Review Table].[Branch], [Loan Table].Borrower = [Annual Review Table].[Borrower]
WHERE ((([Loan Table].[Annual Review Number])=[Annual Review Table].[Annual Review Number]));