Find Matched Records

[JohnB]

How would you do this in Access?

Two tables in 2 different files.
Table-A has a link to Table-B in the other file.

Each table contains a field labeled StockNumber. I want to read each stock
number in Table-A and then search for it in Table-B. If it's found in
Table-B, I want to update the contents of a blank field in Table-B with some
text ("found", or something).

I have not idea how to do that. Any help would be greatly appreciated.

Thanks

 

[Lord Kelvan]

update tableb,tablea set tableb.blankfield = "found"
where tableb.stocknumber = tablea.stocknumber

should do it

 

[JohnB]

Now I'm getting syntax errors on the Select and From statements.

 

[Lord Kelvan]

well what are you trying to do display your query you may have spaces
in your field names or table names

 

[JohnB]

I figured it out.
I don't need the darn Select and From statement for what I'm doing.