Lisa, Have you tried the COLCOUNT(column_name) in a Set fields action that fires on table refresh.
I've tried it and it will count the non-null records in a column of a table field. If I'm beating a dead horse I humbly apologize. John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Wednesday, January 03, 2007 6:40 PM To: [email protected] Subject: Re: COLCOUNT Function Where would you place this SQL code when you are in the Table Field on the form (in Remedy Admin tool)? Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jim Bruce Sent: Tuesday, January 02, 2007 10:15 AM To: [email protected] Subject: Re: COLCOUNT Function Hi Lisa, a direct SQL count should do the trick, unless you are resisting this idea. Example: select count(*) from your-table where particular-column = 'X' Jim Bruce TELUS Mobility 416-279-3455 On Fri, 29 Dec 2006 12:11:54 -0500, Kemes, Lisa <[EMAIL PROTECTED]> wrote: >Listers, > >Would I be able to use the COLCOUNT function to count only the rows >that have a specific value? (I do not want a count of all the rows, >just the rows that have "X" in a particular field). > >Or will I just have to create a temp field and count the rows in a >table loop? > >Thanks in advance! > >Lisa > >_______________________________________________________________________ >____ ____ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >ARSlist:"Where the Answers Are" > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
