Hello. How do I select only those values from SQL that were not repeated. For example:<BR>Mama<BR>Mama<BR>Papa<BR>I only select Papa.<BR>How would my select statement look like ?<BR>Thanx in advance
Did you try "Select Field1 Group By Field1 Where Count(Field1)=1"
Actually Where should probably be HAVING
strSql= "SELECT topics FROM tbd Group by topics Having count(topics)=1" <----- that worked, THANX AGAIN