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"
