Why not make the address the primary key, and use a try/catch statement to catch the error. At 04:34 PM 3/27/02 -0800, you 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 !