Yes, I can do that if I set it up as an ODBC source so that SQL is available (please boss give me a SQL server already!!) and it does work if I put in a proper join statement. I was reading that using native drivers (as in Jet which is what I am using now) defaults to an outer join but there is no way to specify what table is on what side of the join. I've decided to just go ahead and rebuild my reports as I don't have my SQL Server yet and utilizing ODBC won't work with the current way I have the program (as far as maintenance anyway). C'est la vie.