Null Query Help

[cuddles]

My main table has lookup fields. In the main table there are null values and normally I would do a query to say show me the null, however when I say is null, I get nothing back. Is there another way to query for nulls when you see in your list (blank) for lookup tables.

[JoeM]

Does this work in your Criteria?

Is Null Or ""

[cuddles]

Is null or " " comes back invalid data type. Is Null allows me to use it but it just has no returns and I know I have null values. But, there is something different because it is a lookup and it is numeric in the lookup. I hate using lookups but that has to be to work with the forms. I will keep reading to see if I can figure it out because I need to provide all the null values in every column and they vary so we can correct them.

[JoeM]

If it is numeric, this possibly may work:

Is null or 0

If you post the query, and some samples of the values that can be in this field, I can try to recreate the situation here.
(Or you could upload a copy of your database and I could take a look at it when I am at home and can download files - just be sure to remove any sensitive data if you decide to go that route).

[cuddles]

I will just have to sort and copy paste into Excel and then bring all the sheets in based on the primary key that is distinct for each field and then connect them back together. This is because say row 1 might be missing 4 items, then line 2 might miss 1 item then line 3 might miss 4 other items the 2 prior rows are missing. So, I need to get nulls for each line and there are 1million of them. Not all blank. So far I have a max of 16k rows that have null values for the business unit. I would love to post DB but that would require me making a copy, taking out all the HIPAA stuff and then giving just an example. By the time I did that I would have all this copy pasting done. The is null or 0 just gives me nothing back. It has something to do with the main table, the columns are lookups from other tables. So, if I click in cell 2 on row 1 that is bus_id, it gives me a dropdown to select a number.