I have two INNER JOIN statements that both work. I need to be able to combine the two into one sql string. <BR><BR>The first....<BR><BR>listSQL = "SELECT * FROM RListings INNER JOIN Users ON RListings.Agent = ( TRIM(Users.LName) & ' ' & TRIM(Users.FName))"<BR><BR>The second....<BR><BR>listSQL = "SELECT * FROM RListings INNER JOIN Organizations ON RListings.Office = Organizations.Name"<BR><BR><BR>I have tried combining the two like ( Inner Join blah blah Inner Join blah blah) but this does not work. I get syntax errors. I am using an Access db. Thanks!