Hi,

I was a very proficient Access user previously and am starting to use it again after about 2 1/2 years of not using it. I cant remember how to do this.

I have a table that has 970 records, in this there are approx. 25 columns of details. I need to design a query (or report of some sort) that will populate all records that have at least 1 of these cells blank.

I did this and added 'Is Null' under each criteria, but this pulled zero records. Some of these records have some of the info but missing various parts, some records have all the details required.

I hope this makes sense, can someone help me out here, how do I do this??

Thanks!!

Danielle

You'll want to put the Is Null on the Or rows. That should fetch the records that have FieldA null OR FieldB null, etc.

Thanks for the very quick reply!

I think I got lost somewhere there though, maybe I misunderstood what you are saying. I put 'Is Null' under the 'or' row (underneath the criteria row) and I got the same result, first I tried to pnly put it in the 'or' row, but that automatically put it in the criteria row, then I put it in both rows and that didnt work either.

Feeling really lost now....thanks for your help!!

Danielle

25 rows is a lot, a little normalization can go a long way (as Ive just began to learn) and chances are it would be wise to restructure your data to make jobs like these easier...

if you dont have the time to rebuild: I would suggest just doing it by hand... fill in each criteria one at a time then run the query then delete and add to the next field... I mean 25 is a lot but you could probably get the whole thing done in an afternoon...

Only need one query. Each field needs to be checked for Null and Zero Length strings, so the criteria is going to look something like:


Each Is Null Or "" needs to be on its own line for each field being checked.

Perfect!!

Thanks NoahP that worked and I ran my report today!!

Thanks all for the responses.....

Danielle

You are welcome!