I have 9 Tables which are joined by the primary key. (ID#) I used to be able to do a query where I chose the field "ID number" in each table and if any of the ID's had typos, there would be a blank cell for that particular table. Now the query drops that ID # all together. Any ideas what I might have changed? It was a quick way for me to make sure all my ID#'s were correct.