Search results for query: *

Here's the last part of a Select statement after the LIKE portion: SQL = SQL & "' & A1 & A2 & A3 & A4 & A5 & A6 & A7 &"'" A1 to A7 will analysis each character in the 7 character querystring. I'm using a hyphen in the query to indicate if user wants a wildcard in this position. Ex...

I have a field in the database that supports up to 8 characters. I would like to use * as a wildcard type and ? as a wildcard type. So, if I used 4AWL* and 4AWL??99, the * is for anything after and the ?? is just for characters 5 and 6 in that field. So, for me, building this type of SQL...

The following select statement works and I'm using the % because this number has a hyphen and any two numbers after that that I need, for example 00010044-01: SQL6 = "SELECT NO, LNAME, FNAME, MNAME, DOB" SQL6 = SQL6 & " from COMP9.DBO.proc2" SQL6 = SQL6 & " Where NO like '00010044%'" set rs6...

So, when I enter the full website of http://Server/finance/costreport.htm for a link I'm successful. However, the main report that i'm running is within the same folder that this link is on. Since this report goes to several Crystal servers, I would like to just say /costreport.htm or...

I have a VB program that I made several years ago and it's not working on my new computer. I'm running VB 6.0 and I thinked I've narrowed down the problem. When I run the program, I trapped the problem to a particular line. Here's the error message: Run-time error '-2147417848 (80010108)'...

I have a field with an event number. Example, 06-001-019. 06 is for the year, 001 is the julian date, and 019 for the event of the day. My goal is to create a query that will display the date of the event automatically. Any ideas? TIA

I'll make this simple. I have an Access Database that list's every employee's number (Personnel.EmpNo) I link the Access document to an Oracle DB via Personnel.EmpNo <-> Sales.Emp_No In that same Sales table, there is a field called Sales.Ticket, which is a unique number. Then, I do a count...

How to see all business names? Table 1 Business.ID Business.Name Table 2 Comment.ID Comment.ReferenceID Comment.Comment Left outer join to Business.ID <-> Comment.ReferenceID Now, if I list all Business.Name, I will see all Business names. For the most part, every Business.Name will have...

I'll simplify to the following: table1.BusinessName table1.ID tableA.RefID tableA.comment tableA has a many to one relation. table1.ID <-> tableA.RefId Now the question. #1 - I would like to identify every table1.BusinessName that doesn't have at least one tableA.comment that DOES NOT have...

I have 40 vehicles within a field called Log.VehName. I have another field called Log.Date_Time. The third field is called Log.Mileage. My goal is to create a report with Log.VehName as the group and to only see the last 5 reported mileages.

I have a report that will say something like 15.75 or 6.04567 for a time value. With that said, 15.75 equates to 15 minutes and 45 seconds (.75). What formula, if any, would I use to create something that replaces 15.75 with two values: Minutes = 15 Seconds = 45 Please keep in mind that I...

How to get date time to display like 01/01/2005 16:14:10? mm/dd/yyyy Here's something that I found works against an Oracle database. However, I'm not getting the same results against a SQL 2000 database. Can anyone point out the correction needed? With the following, the time displays...

We have a database that is no longer in use as of 4/30/05. The replacement database starts at 5/1/05 and a vendor attempted to imported data from the older database but had errors. Since the data is not as expected, anyone who runs the Crystal report against the new system and includes a date...

We have a vehicle report that lists what employees are in the truck at any given time. However, each employee's ID number lists in on one row for the same vehicle. Is there a way to get the values multiple employees within a vehicle on just one row? Here's some info so you can get a picture...

We have a vehicle report that lists what employees are in the truck at any given time. However, each employee's ID number lists in on one row for the same vehicle. Is there a way to get the values multiple employees within a vehicle on just one row? Here's some info so you can get a picture...

We have a vehicle report that lists what employees are in the truck at any given time. However, each employee's ID number lists in on one row for the same vehicle. Is there a way to get the values multiple employees within a vehicle on just one row? Here's some info so you can get a picture...

I find it very easy to use Crystal, but would like to convert many of my reports to ASP since I find ASP more time consuming. Are there any tools out there that will do a decent job?

Many of our users accidently hit the enter button when attempting to tab through a form. For some of the programs that they use, the enter key can be used as a tab key also. Anyway, is there a way in the asp, I'm using VBscript, to not send the form when the ENTER key is hit. The only way...

In the network connections, I have two networks in the "LAN or High-speed Internet" connections. In the task bar area, both connections show up as an icon and both look like a computer icon. So, we have third party switching software that switches between networks, but at a glance a user can't...

I'm trying to build a soundex formula in my last name and first name selection statement. Unfortunately, I'm using the example in CR 8.0 and can't get it to work. Here's their example: If Soundex{customer.LAST NAME} = Soundex (&quot;Snider&quot;) Then {customer.LAST NAME} Else...