Forum Discussion
Email criteria query only "gmail"
This is how trouble-shooting works.
Try one thing first, isolate the individual parts--in this case the criteria for email.Once you verify that it works as required, the next step is to add the second criteria, either the IN() clause for states or the word in the Notes field.
Once you verify the first two work as required, you can add the third and test again.
I've repeatedly stated I can't test for you without adequate sample data. I can suggest SQL Syntax to use, but it's on you to verify it.
There should be only ANDs between the three criteria, because you want all three to apply:
In specific States AND with specific email hosts AND with a specific value in the Notes Field.
AND ( ( [fans with email only table].[email] ) LIKE "*@mail.com" )
And did you try it with ONLY that one criteria, i.e. without the state filter and the note filter?
that would be
WHERE [fans with email only table].[email] ) LIKE "*@mail.com"
As previously, noted, I can't test without sample data.
This is how trouble-shooting works.
Try one thing first, isolate the individual parts--in this case the criteria for email.Once you verify that it works as required, the next step is to add the second criteria, either the IN() clause for states or the word in the Notes field.
Once you verify the first two work as required, you can add the third and test again.
I've repeatedly stated I can't test for you without adequate sample data. I can suggest SQL Syntax to use, but it's on you to verify it.
There should be only ANDs between the three criteria, because you want all three to apply:
In specific States AND with specific email hosts AND with a specific value in the Notes Field.- no, I did not try that, but if that worked, how would that help me? I don't want gmail users from all over the country, I only want the ones in the neighboring states including IL
