Hmm...

Try to define the join query you want in Access and save it in the db. Then add a recordset class based on that query (not sure if the wizard can do it though).