Re: Remedy SQL query assistance... Please Help.

2007-12-18 Thread Grooms, Frederick W
red From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Martinez, Raul (ISD, IT) Sent: Tuesday, December 18, 2007 3:21 PM To: arslist@ARSLIST.ORG Subject: Remedy SQL query assistance... Please Help. ** We would like to do this in Acc

Remedy SQL query assistance... Please Help.

2007-12-18 Thread Martinez, Raul (ISD, IT)
d the macro that we are using. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eli Schilling Sent: Friday, December 14, 2007 7:21 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy SQL query assistance... Please Help. ** Raul, are you running this que

Re: Remedy SQL query assistance... Please Help.

2007-12-14 Thread Eli Schilling
TECTED] On Behalf Of Martinez, Raul (ISD, IT) Sent: Friday, December 14, 2007 12:35 PM To: arslist@ARSLIST.ORG Subject: FW: Remedy SQL query assistance... Please Help. ** From: Zaldivar, Jack (ISD, IT) Sent: Friday, December 14, 2007 3:33 PM To: Martinez, Raul (ISD, IT) Subject: RE: Remedy

FW: Remedy SQL query assistance... Please Help.

2007-12-14 Thread Martinez, Raul (ISD, IT)
From: Zaldivar, Jack (ISD, IT) Sent: Friday, December 14, 2007 3:33 PM To: Martinez, Raul (ISD, IT) Subject: RE: Remedy SQL query assistance... Please Help. SELECT "HPD:HelpDesk"."Assigned To Group+", "HPD:HelpDesk"."Assigned To Individual+&qu

Re: Remedy SQL query assistance... Please Help.

2007-12-14 Thread Eli Schilling
ne') Group by Submitter Is that what you were hoping for? Cheers! Eli From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Martinez, Raul (ISD, IT) Sent: Friday, December 14, 2007 7:47 AM To: arslist@ARSLIST.ORG

Re: Remedy SQL query assistance... Please Help.

2007-12-14 Thread Darrell Reading
__ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Martinez, Raul (ISD, IT) Sent: Friday, December 14, 2007 10:34 To: arslist@ARSLIST.ORG Subject: Re: Remedy SQL query assistance... Please Help. ** Yes there is a limitation in affect right now o

Re: Remedy SQL query assistance... Please Help.

2007-12-14 Thread Martinez, Raul (ISD, IT)
to do this in Access either that would be helpful. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Friday, December 14, 2007 11:50 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy SQL query assistance... Please Help. ** What databa

Re: Remedy SQL query assistance... Please Help.

2007-12-14 Thread Frank Caruso
D:HelpDesk".Status<>'Resolved' And "HPD:HelpDesk".Status<>'Closed') AND > ("HPD:HelpDesk"."Create Time" ORDER BY "HPD:HelpDesk"."Case ID+" > > 11:11:11 AM > > *?* > > that's just an e

Re: Remedy SQL query assistance... Please Help.

2007-12-14 Thread Martinez, Raul (ISD, IT)
D:HelpDesk"."Assignee Login Name"='Jack Zaldivar') AND ("HPD:HelpDesk".Status<>'Resolved' And "HPD:HelpDesk".Status<>'Closed') AND ("HPD:HelpDesk"."Create Time"mailto:[EMAIL PROTECTED] On Behalf Of Fr

Re: Remedy SQL query assistance... Please Help.

2007-12-14 Thread Frank Caruso
07 9:47 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Remedy SQL query assistance... Please Help. > > ** > > Can anyone assist me in either in connecting an ODBC connection to Remedy > through Access or with creating a SQL search query for $DATE$ function? I am > needing

Re: Remedy SQL query assistance... Please Help.

2007-12-14 Thread Evans.Randy
ystem discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Martinez, Raul (ISD, IT) Sent: Friday, December 14, 2007 9:47 AM To: arslist@ARSLIST.ORG Subject: Remedy SQL query assistance... Please Help. ** Can anyone assist me in either in connecting an ODBC connection to Remedy through Access or

Remedy SQL query assistance... Please Help.

2007-12-14 Thread Martinez, Raul (ISD, IT)
Can anyone assist me in either in connecting an ODBC connection to Remedy through Access or with creating a SQL search query for $DATE$ function? I am needing to grab all submitted tickets for current day based on certain submitters. I already have a remedy macro created but it would be easier with