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"
