Look up LASTCOUNT, I think that might be the easy solution to what you're looking for.
Ben Cantatore Remedy Administrator Avon (914) 935-2946 "Mosco, John D." <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 05/25/2007 08:48 AM Please respond to [email protected] To [email protected] cc Subject Re: COLSUM - How do I make a field show the sum of all tickets with a certain category or distict attribute ? ** ALL, I am sure this is an easy one. I have a table that list all the tickets that meet a certain distinct attribute in this case a field called ?ServiceYesNo? Values ?In Service? or ?Out of Service?. The table displays fine but I don?t want a list, all I want is a count. I am pretty sure I should use the COLSUM Function. I created an active link with a set fields, choosing the column and choosing ?COLSUM? as the value. Oh great remedy gurus help this mere mortal that I may thwart the request for constant reporting data from my highers by giving them real time data??(Today IS Friday) THANKS !! John Mosco W01/GS-11 IT Coordinator Customer Support Manager PNG JFHQ J6 Com: 717-861-8143 DSN: 312-491-8143 Fax: 717-861-8414 CALL, FAX, or EMAIL the Pennsylvania National Guard Operations Desk and start a REMEDY Ticket for all RCAS issues or requests. Operations Desk Commercial: 717.861.2899 Operations Desk DSN: 312.491.2899 Operations Desk FAX: 717.861.8414 [EMAIL PROTECTED] "Do not withhold good from those who deserve it, when it is in your power to act." Proverbs 3:27 __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
