Hi Pamela, You need to replace the double quotes with single quotes for this to work.
Regards, Chris -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Pamela Morales Sent: 19 June 2015 21:32 To: arslist@ARSLIST.ORG Subject: Re: Count CRQ related an INC in status=<"Completed" Hi Bruce, I tried what you recommend, but I got an error: Invalid column name 'INC2014000903'. (SQL Server 207) (ARERR 552). I'm trying to do this SQL Sentence: SELECT COUNT (*) FROM dbo.CHG_Association_ID02Join WHERE (Request_ID01 ="$Incident Number$" AND RequestID02_Status>=10) I will be grateful with your help Thanks Pamela _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"