Report Query

[Steve]

I am trying to make a query (or something in the report) that will take 7
fields from the table, and if ANY of the 7 fields is missing data, then it
will show up in the query. I try to use the "Is Null" command but that says
that they ALL have to be missing to show up. I want it if ANY of the
combination in the 7 fields is missing to show up.

 

[KARL DEWEY]

Null_Check: IIF([Field1] Is Null OR [Field2] Is Null OR [Field3] Is Null
OR [Field4] Is Null OR [Field5] Is Null OR [Field6] Is Null OR [Field7] Is
Null, 1, 0)

And then use criteria 1

 

[Steve]

Thanks Karl...though I am not as advanced in the programming as you are, so I
have another question. Do I put this in the report filter? Or the on the
criteria line of the query? What do you mean put criteria 1?
--
Steve

Null_Check: IIF([Field1] Is Null OR [Field2] Is Null OR [Field3] Is Null
OR [Field4] Is Null OR [Field5] Is Null OR [Field6] Is Null OR [Field7] Is
Null, 1, 0)

And then use criteria 1

--
Build a little, test a little.

I am trying to make a query (or something in the report) that will take 7
fields from the table, and if ANY of the 7 fields is missing data, then it
will show up in the query. I try to use the "Is Null" command but that says
that they ALL have to be missing to show up. I want it if ANY of the
combination in the 7 fields is missing to show up.

 

[KARL DEWEY]

You put it in a blank of the Field row of query in design view and the
criteria in the criteria row below it.
--
Build a little, test a little.

Thanks Karl...though I am not as advanced in the programming as you are, so I
have another question. Do I put this in the report filter? Or the on the
criteria line of the query? What do you mean put criteria 1?
--
Steve

Null_Check: IIF([Field1] Is Null OR [Field2] Is Null OR [Field3] Is Null
OR [Field4] Is Null OR [Field5] Is Null OR [Field6] Is Null OR [Field7] Is
Null, 1, 0)

And then use criteria 1

--
Build a little, test a little.

I am trying to make a query (or something in the report) that will take 7
fields from the table, and if ANY of the 7 fields is missing data, then it
will show up in the query. I try to use the "Is Null" command but that says
that they ALL have to be missing to show up. I want it if ANY of the
combination in the 7 fields is missing to show up.

 

[Steve]

This worked great. THANKS SO MUCH!
--
Steve

You put it in a blank of the Field row of query in design view and the
criteria in the criteria row below it.
--
Build a little, test a little.

Thanks Karl...though I am not as advanced in the programming as you are, so I
have another question. Do I put this in the report filter? Or the on the
criteria line of the query? What do you mean put criteria 1?
--
Steve

Null_Check: IIF([Field1] Is Null OR [Field2] Is Null OR [Field3] Is Null
OR [Field4] Is Null OR [Field5] Is Null OR [Field6] Is Null OR [Field7] Is
Null, 1, 0)

And then use criteria 1

--
Build a little, test a little.


:

I am trying to make a query (or something in the report) that will take 7
fields from the table, and if ANY of the 7 fields is missing data, then it
will show up in the query. I try to use the "Is Null" command but that says
that they ALL have to be missing to show up. I want it if ANY of the
combination in the 7 fields is missing to show up.