Do not want to see blank fields

[cntdavis]

I'm trying to make a query for a table that some of the records are blank under certain field names. Can I make a parameter query that does not return the blank field names at all?

 

[Rich]

Not Is Null in the criteria section

 

[cntdavis]

I tried that and the query returned no records at all. Is that because there are multiple field names? Doesn't that make it an AND statement?

 

[pm709]

"Not is null" or "Is not null"?

 

[Pat Hartman]

You cannot use criteria to alter the columns that are selected by a query. The criteria controls the selection of rows. If what you want to do is to eliminate rows where ALL columns are null, the criteria should look something like:

Where Not (FldA Is Null AND FldB Is Null AND FldC Is Null);

Formulating compound conditions that include the NOT operator can be tricky.