Hello all - - I was wondering if it is possible to create an access query that would provide a report or query where fields are blank when we like them to be populated. what I don't want is a report that shows all the data and the null data. For example if I had a table that contained name and address information such as: ID, FirstName, LastName, Phone, Cell, Address, City, State, Zip...etc

lets say I want a result set that shows me every ID that is missing something, but not show me that row that contain the 'not' missing...In other words, lets say ID 0001 is missing a LastName and ID 0002 is missing a Phone number. The return would simply be:

ID
0001 LastName
0002 Phone



Is this possible with a query?