Ok maybe this is not the correct forum, but i need help, I am currently in the process of designing a database that i am going to create in Access 2000. What I want to know is if I can have some fields of certain tables as optional(not the primary key obviously), which i know i can, and then filter to show the entrys which have this field (regardless of what it contains) and also alternatively search for the entrys which dont have this field, or entry in the field....make sense? please help

I have posted a number of answers explaining null values recently. See if you can find them with the search option.

The bottom line is that null values ALWAYS need to be treated as a special case. For example, if you want to find all occurances where yourFld <> "A" and some of those values might be null, you would need to use -
Where YourFld <> "A" Or YourFld Is Null;