That is not going to fix the problem. When I put the code into vb for the sql string it only returns the one recordset and puts that into tbltmpReport when in access it returns 2 records as it should. I am not sure why the string works in access just fine but the exact string in vb does not return the correct stuff. Any help is greatly appreciated.