Only showing after @ duplicates

[sanderijken]

I have a column with e-mail adressess in it. I want a duplicate query showing
only the duplicates what comes after the @ sign.

Example:

(e-mail address removed)
(e-mail address removed)
(e-mail address removed)

Result I want
@hotmail.com 2
@gmail.com 1

 

[Guest]

Replace the [x] with the name of your field.
SELECT Right([x],Len([x])-InStr([x],"@")+1) AS Expr1, Count(a.x) AS CountOfx
FROM [YourTable]
GROUP BY Right([x],Len([x])-InStr([x],"@")+1);