Hi, I need know how can I get in a field the result of
SELECT COUNT (*) FROM CHG_Association_ID02Join WHERE (Request_ID01 =$Incident Number$ AND RequestID02_Status>=10) What I need is that no one could resolve or close or cancel and incident if it has one or more related changes in status less than completed, closed or canceled. I was trying to do this by a filter with a Direct SQL command with this query, but I don't know how to take the number of the result of the query. If you have any other solution please, let me know. Best Regards, Pamela _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"