If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report Query
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" wrote: 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 |
#2
|
|||
|
|||
Report Query
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" wrote: 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" wrote: 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 |
#3
|
|||
|
|||
Report Query
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" wrote: 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" wrote: 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" wrote: 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 |
#4
|
|||
|
|||
Report Query
This worked great. THANKS SO MUCH!
-- Steve "KARL DEWEY" wrote: 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" wrote: 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" wrote: 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" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|