It seems like this ought to be very simple but its not working for me. I've written a document and received many comment from reviewers, all of which I have entered into a table. For some comments, I made an initial response and for others, there is a second response (after cooler heads have prevaled).
Therefore, for each comment there is a Response 1 and a Response 2 (both are in memo fields). Generally, Response 2 is a Null. I want to build a make table query that has only my final response in it. I need a way to select either response 1 or response 2. So I wrote this expression:
Fnl_Rspns: IIf([tbl Comments]![Sec_Response]="",[tbl Comments]![Response],[tbl Comments]![Sec_Response])
Clever but it sets my variable Fnl_Rspns equal to a response only when the expression is false. When the expression is true, the expression sets Fnl_Rspns to a null value, not the first response as intended. What am I doing wrong?
Therefore, for each comment there is a Response 1 and a Response 2 (both are in memo fields). Generally, Response 2 is a Null. I want to build a make table query that has only my final response in it. I need a way to select either response 1 or response 2. So I wrote this expression:
Fnl_Rspns: IIf([tbl Comments]![Sec_Response]="",[tbl Comments]![Response],[tbl Comments]![Sec_Response])
Clever but it sets my variable Fnl_Rspns equal to a response only when the expression is false. When the expression is true, the expression sets Fnl_Rspns to a null value, not the first response as intended. What am I doing wrong?
