Okay I was told to fix up this database and I can't figure it out. I want to change the code but I can't figure it out. Select Case optGroup Case 1 'Reports qry$ = qry$ & " INTO tmp_report IN 'C:\ACCESS\Database.MDB'" tblName$ = "tmp_report" It's from a query builder form that someone set up. I want it to just read the table tmp_report that is already in the database and not have to link it to this other one. Anyone have any clue how to rewrite that code??