Search results for query: *

I am pulling all the fields that I want - I guess I can take out some that I don't need I didn't know if there was a better way to write the statement - I want to have both tables linked so I can write multiple reports off of the same statement - like having a dictionary or one tabel - you know?

Query in full SELECT "gci_requests"."id","gci_requests"."category_name", "gci_requests"."persid", "gci_requests"."ref_num", "gci_requests"."summary", "gci_requests"."description", "gci_requests"."open_date", "gci_requests"."last_modified_date", "gci_requests"."close_date"...

I want to use crystal for the rest of my grouping, parameters, etc. I am running this over an ODBC connection. Since I need to join the tables by modfiying a field - this is the only way I came up with this statement Thoughts

I have to use a SQL command in order to write a crystal report and join 2 tables. The reason for this is that I need to link 2 fields but remove a few letters at the beginning or one to get them to link FROM "mdb_rpt"."dbo"."gci_requests" "gci_requests" LEFT OUTER JOIN...

Hi All - So I am having a problem with a report I am trying to create in crystal XI I have 2 fields - Reported by and Assigned To I want to total the Incident numbers with a distinct count for the Analyst that would either be Reported By or Assigned To I also want a distinct Count of the number...

when you're good - you're good Thanks a bunch =)

now getting an error at the part after else that this array must be subscripted for example array [i ??? can't get it to work....

that gives me an error a subscript must be between 1 and the size of the array if I take out the txt 2 it works but shortens it too much....thoughts? Thanks

what if I am getting an error that reads string length is less than 0 or not an interger? If I take out the -1 then it works ok but still leaves on too much text.I only want text.text. can I do this?

I have a field that is being pulled that I want to summerize. For example I have one field that pulls a drill down of categories ex) Server.NetApp Filer Telecommunications.Account Management I want to write a formula to stop the text at the second period and group totals by that Is there a...

Hi All - Is there a way to use SMS to find out registry information on a users machine like printer information, network drives.......

Hi All - I have an inno setup .exe that I am running silently by /silent - in the install I am getting an install of a toolbar. Is there a command to either record my install or put a command in to do not install the toolbar? thanks

so where do I fit this in? Set objFileSys = CreateObject("Scripting.Filesystemobject") Set objShell = WScript.CreateObject("WScript.Shell") strStartMenu = objShell.SpecialFolders("AllUsersStartMenu") If Not objFileSys.FileExists("c:\Program Files\Microsoft Office\OFFICE11\OIS.EXE") Then...

I gotcha now..........Thanks SO much!

Hi All - what is the syntax to rename a shortcut on your desktop? help is apprecaited Thank -L

is there a way to get this as a prompt though? I need one for date range and then a hard code for the time range - you know what I mean?

I am just getting a true/false value when I use that

Hi - I have a field that is unix time (View_Request.open.date). The field is a number and I have converted to a date/time by the formula dateadd("s",{View_Request.open_date}-14400,#01/01/1970#) what I need to do is run a report by time range, for example all Incidents opened between 5pm and 7am...

I don't get that option. I am Outlook 2003 and it is set up as Exchange. But I don't get the options that you are speaking of - I am unable to get any options when I right click on the shortcut bar - I can select add a new group or a new shortcut - but that brings me into Outlook folders , etc...

Hi All - Is there a way to add a network folder to Outlook 2003? Also - Can you set up shortcuts to My Documents and stuff too?