... or do a set fields to a temp field from the form the table references using the qualification that gives the required result and use the $LASTCOUNT$ keyword.
Cheers Peter _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: 30 December 2006 22:30 To: [email protected] Subject: Re: COLCOUNT Function To add to L. J., use EXTERNAL keyword to produce the results that L. J. described. Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. ----- Original Message ---- From: L. J. Head <[EMAIL PROTECTED]> To: [email protected] Sent: Friday, December 29, 2006 12:25:46 PM Subject: Re: COLCOUNT Function ** Either use a table loop....or change the qualification of the table to display only the records that you want to count _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Friday, December 29, 2006 10:12 AM 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___ __20060125_______________________This posting was submitted with HTML in it___ __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
