Lisa, I think you can count just the X if the other rows are blank for that column. If you have X or Y or Z and you want to count the X's you need to do a table loop. Use the COLCOOUNT(Column_name) and it will only count non-NULL rows for that one column. HTH,
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 ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Friday, December 29, 2006 12:12 PM To: [email protected] Subject: COLCOUNT Function ** 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 __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
