Report Query

  • Thread starter Thread starter Steve
  • Start date Start date
S

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.
 
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
 
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


KARL DEWEY said:
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.


Steve said:
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.
Click to expand...
Click to expand...
 
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.


Steve said:
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


KARL DEWEY said:
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.


Steve said:
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.
Click to expand...
Click to expand...
Click to expand...
 
This worked great. THANKS SO MUCH!
--
Steve


KARL DEWEY said:
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.


Steve said:
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


KARL DEWEY said:
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.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top