Raj, sum(fieldname) is the function used across most standard databases to do something similar to a colcount()
update table tablename set fieldname = sum(field2name) where your conditions... Just curious - what are your actions on your filter that doesn't seem to work? Hope this helps.. Cheers Joe ________________________________ From: Raj <[email protected]> To: [email protected] Sent: Mon, May 10, 2010 11:41:19 AM Subject: COLCOUNT not working Hi All, Setting a field with COLCOUNT($COLUMN FIELD ID$) in a Set Fields action of a Filter on Submit. Seems is it not working. Always setting the field to a constant value of 15. Would like to set the field with the number of rows in that particular table. Is the any other way around to do this? How can it be done with the help of Direct SQL ? Please advise. Thanks, Ravi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
