Could someone point me towards a resource that could help me achieve this please.<BR><BR>thanks<BR><BR>KS
Sorry forgot to mention, its Access2000.
You want me to email Bill? Look at his name, search for a thread with my particular problem, what????
It's something with the FROM and you specify a path or something.<BR><BR>It's in there.. just read the Help.
Search for you particluar problem in the Database forum and Bill Wilkinson ... you will find examples
At the risk of sounding like a dumb sh!t, where is the MS Access help section??
Open your database.<BR><BR>Go to the Help Menu.
searching the terms: <BR>joining multiple tables multiple databases<BR>joining multiple tables<BR>joining tables from more than 1 database<BR>etc etc