Looking for way to validate email addresses in your Access query, then this validation rule will help.
Not Like “*[email protected]?*.?*” And Like “*[ ,;]*”
This rule will give you all matching invalid email addresses.
Credit to Remi for this great tip