Hi. I am having a problem with a query. There are various fields involved but the important ones are a send date, withdrawal, and 4 responses. I then also have a calculated field which is 3 months after the sent date.
I want the query to show me everyone who has a sent date, does not have data in the withdrawal field, and is missing one or more of the 4 possible response fields (as in they are missing). The calculated field is a parameter field so users choose the date after which they want to see.
In the criteria field I have "Is Not Null" for the date, "Is Null" for the withdrawal and >=[Enter the date you want to see after] in the calculated field.
I had then put Is Null on the first criteria line for the first response and on the second line for the second and so on hoping that would then work so that if any of them were missing they would be included.
I then read that it doesn't really matter about the rows across fields that is just in case there are more options in one field. So then I thought it wouldn't bring anyone up but actually it returns everyone in the database.
Any ideas how I build a query that shows me who I want?
I'd be very grateful for any advice, thanks.
I want the query to show me everyone who has a sent date, does not have data in the withdrawal field, and is missing one or more of the 4 possible response fields (as in they are missing). The calculated field is a parameter field so users choose the date after which they want to see.
In the criteria field I have "Is Not Null" for the date, "Is Null" for the withdrawal and >=[Enter the date you want to see after] in the calculated field.
I had then put Is Null on the first criteria line for the first response and on the second line for the second and so on hoping that would then work so that if any of them were missing they would be included.
I then read that it doesn't really matter about the rows across fields that is just in case there are more options in one field. So then I thought it wouldn't bring anyone up but actually it returns everyone in the database.
Any ideas how I build a query that shows me who I want?
I'd be very grateful for any advice, thanks.