Email criteria query only "gmail"

What is the criteria for a query if I only want to email my customers with a "gmail" type email? I've tried a hundred things, Like "gmail" Like "*gmail" Like "gmail.com" and every other variety inc...

access

George_Hepworth
Jul 02, 2023
DougSaleeby
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.

DougSaleeby

Copper Contributor

Jul 02, 2023

George_Hepworth I'm not sure why it automatically generates criteria in the state field that is a duplicate, I've tried to delete it, but it keeps coming back. Anyway, this returns results that are almost right but there are several other emails returned that are not gmail.com

SELECT DISTINCTROW [Fans with Email only Table].FNAME, [Fans with Email only Table].LNAME, [Fans with Email only Table].CITY, [Fans with Email only Table].STATE, [Fans with Email only Table].EMAIL

FROM [Fans with Email only Table]

WHERE ((([Fans with Email only Table].STATE) Like "il" Or ([Fans with Email only Table].STATE) Like "IL" Or ([Fans with Email only Table].STATE) Like "in" Or ([Fans with Email only Table].STATE) Like "IN" Or ([Fans with Email only Table].STATE) Like "mi" Or ([Fans with Email only Table].STATE) Like "MI" Or ([Fans with Email only Table].STATE) Like "wi" Or ([Fans with Email only Table].STATE) Like "WI" Or (([Fans with Email only Table].STATE) Like "il" Or ([Fans with Email only Table].STATE) Like "IL" Or ([Fans with Email only Table].STATE) Like "in" Or ([Fans with Email only Table].STATE) Like "IN" Or ([Fans with Email only Table].STATE) Like "mi" Or ([Fans with Email only Table].STATE) Like "MI" Or ([Fans with Email only Table].STATE) Like "wi" Or ([Fans with Email only Table].STATE) Like "WI")) AND (([Fans with Email only Table].EMAIL) Like "*.gmail.com")) OR ((([Fans with Email only Table].STATE) Like "il" Or ([Fans with Email only Table].STATE) Like "IL" Or ([Fans with Email only Table].STATE) Like "in" Or ([Fans with Email only Table].STATE) Like "IN" Or ([Fans with Email only Table].STATE) Like "mi" Or ([Fans with Email only Table].STATE) Like "MI" Or ([Fans with Email only Table].STATE) Like "wi" Or ([Fans with Email only Table].STATE) Like "WI") AND (("or") Like "zebra")) OR ((([Fans with Email only Table].STATE) Like "il" Or ([Fans with Email only Table].STATE) Like "IL" Or ([Fans with Email only Table].STATE) Like "in" Or ([Fans with Email only Table].STATE) Like "IN" Or ([Fans with Email only Table].STATE) Like "mi" Or ([Fans with Email only Table].STATE) Like "MI" Or ([Fans with Email only Table].STATE) Like "wi" Or ([Fans with Email only Table].STATE) Like "WI") AND (([Fans with Email only Table].NOTE) Like "Zebra"));

George_Hepworth

Silver Contributor

Jul 02, 2023

Thank you. That's a gnarly SQL statement and it will, no doubt, take a while to sort it out -- especially with no sample data to test against.

I will say that I see a lot of "OR" concatenators and that's most likely going to turn out to be where the problem lies.

Without this SQL, though, it would have been 1,000 to 1 shot that anyone could have offered any useful suggestions. 🙂

Forum Discussion

Email criteria query only "gmail"