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.
Please show us:
--Some sample data, not real email addresses, but samples that could be found in the table.
--The actual SQL from your query. Not a screenshot of the query design grid please. Copy and paste the SQL.
We might be able to identify the problem.
George_Hepworth what I'm trying to find is the query syntax to filter out only my friends who use Gmail. I have tried a bunch, "*.gmail.com" and every variety of that, does not work. The results always include some other users.
- Is it possible to provide samples of the email addresses you are using?
Is it possible to copy and paste the SQL from your query into your reply?
"...does not work." is too generic to give us any idea what to suggest. Actual data to work with makes all the difference.- They are just normal email addresses like email address removed for privacy reasons or email address removed for privacy reasons. I created a query that singles out the states near Illinois and also singles out people with email addresses and now I want to add the criteria that I only get Gmail users in my query results and I have tried many different strings of criteria and none of them work properly
- Please, I'm not kidding about the actual SQL. It would be very helpful.
