Lisa, Direct SQL view created using SELECT DISTINCT CREATE VIEW AS followed by the SQL equivalent of the qualification you have used in the current table field and a table created from that view is one option...
The above view and a SELECT COUNT(*) FROM that view is another option to set your integer field to the count value.. Is there any direct way from the ARS to do this? Nope - to the best of my knowledge you dont have a direct way, but you can work your way around using the above options... Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. ----- Original Message ---- From: "Kemes, Lisa" <[EMAIL PROTECTED]> To: [email protected] Sent: Friday, January 19, 2007 4:15:12 PM Subject: COLCOUNT minus Duplicates..... ** Listers, I'm trying to do a COLCOUNT on a table, but I only want to do a count on the unique rows, I don't want to count any duplicates. Is there an easy way to do this? ____________________________________________________________________________________ Sucker-punch spam with award-winning protection. Try the free Yahoo! Mail Beta. http://advision.webevents.yahoo.com/mailbeta/features_spam.html _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
