I have made a phone listing using access to store the data. I have each office blocked off in it's own table on the display page. To do this I have made a seperate SELECT by Office query with a loop until EOF before each table. It works great but the code is a mile long. Is there a way to do one SELECT query and build a new table for each different Office.