Select Query not working

Pippa1

Registered User.
Local time
Yesterday, 19:34
Joined
Oct 2, 2017
Messages
30
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.
 
instead of trying to do it all in 1 query,
make 1 query for each.
Once those are working, you can put them all into 1 Union query.
 
OK thanks. I've created the 4 separate queries and they are all working. Before I try to learn how to do the union query can I just check something? If someone is missing all four pieces of information and hence appear in all for query outputs will they then appear 4 times in the union query output? I ideally only want them in there once.
 

Users who are viewing this thread

Back
Top Bottom