You could always allow the email address to go through and use the DISTINCT keyword E.g. SELECT DISTINCT email_address FROM TableName Regards. Kevin WebDev Ltd Parteen, Nr. Limerick, Ireland. Tel: 087-2456123 Email: sinnot at iol.ie On Thursday, March 28, 2002 12:35 AM, George Klingenhoffer [SMTP:georgeklingenhoffer at hotmail.com] wrote: > I'm working on a mailing list feature; how do I check for duplicate email > addresses in the Access database while adding if it does not exist or throw > up an error message if it does. > > Would that require two SQL statements? One to query every address and > compare the address to be added to each address in the database then one to > add the address or is there a single SQL statement for this? Thanks! > > > -- > For unsubscribe and other options, including > the Tip Harvester and archive of thelist go to: > http://lists.evolt.org Workers of the Web, evolt !