> > Try using a COUNT in your SQL select formula. > > e.g. > > Select count(colname) from tablename where colname='myvalue'; > > If it returns a 0 then that value doesn't exist. > If it returns anything then that is the number of times the value exists. Of course, thanks. Rik