Click to See Complete Forum and Search --> : Query Multi Record sets


PeterP
March 20th, 2001, 07:03 AM
Is it possible perform a join between two differnt records sets(different mdb).

What I would like to do is to update a field where ID's match and street are different. This comparision would be between to differnt tables in two different mdb files.


Thanks

Peter

James Longstreet
March 20th, 2001, 01:04 PM
should be possible if the tables are linked into the database; other than that it is just a simple join.



Jim Hewitt
Software Developer
Liberty Tax Service
www.LibertyTax.com