An easy one

[mmwdmr]

I have worked with Access for a few years but am no expert so this one should be a cinch for someone who is. I have two tables. I am comparing records in table A to records in table B. If a record XX in table B indicates activity for record XX in table A, I just need to update a field in table A to reflect the activity found in table B. Obviously, it would be some sort of Update query but I can't put the mechanics and code together in my head.

I know this isn't a lot of detail but it is really that basic. Thanks!

 

[PHV]

UPDATE tableA INNER JOIN tableB ON tableA.[xx field] = tableB.[xx field]
SET tableA.[some field] = tableB.[some field]
WHERE some condition probably on tableB

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mmwdmr]

Dumb question - would this by the SQL statement in an Update Query then?

 

[Golom]

This would be an UPDATE statement that you run from the query window after inserting the correct field, table and condition specifications where PHV has used italics.