i am creating a DB for all the software installed on PC's i have a table that if a certain software is installed i would enter the version number, and if it is not installed then i would just leave it blank. How can i create a query that will disregard all the null fields (meaning that software is not installed on that specific pc) and jsut show the records that have a version number in it. I am almost positive there is a setting for this, i just can't find it, don't think you have to put some kind of code behind this to create the query. Any help would be much appreciated.