Thanks to everyone for the help I've received. I took the easy way out for now and just created another table only showing the fields that are equal to "X" and then doing a COLCOUNT on that table.
I tried doing a table loop and it just wasn't working out. It would have worked out if this was the only table that I was looping, but I have 3 tables that I'm looping through, and it was just getting to be a mess. I'm going to explore doing a set fields using SQL though in the future so I won't need that extra table! Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: Thursday, January 04, 2007 9:41 AM To: [email protected] Subject: Re: COLCOUNT Function 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
