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...

Here's the last part of a SQL statement after the LIKE portion: SQL1 = SQL1 & "' & A1 & A2 & A3 & A4 & A5 & A6 & A7 &"'" This will take all 7 letters/numbers with success. However, I'm trying to create a wildcard in each of the 7 spots if it's called for. Ex, *ABC*23, or 1ABC12*, etc. Since...

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...

Perfect. Thanks

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...

string value in Select statement? DIM EntryNo is set EntryNo = "" This first select statement against a SQL DB works: SQL6 = "SELECT NO, LNAME, FNAME, MNAME, DOB" SQL6 = SQL6 & " from COMP9.DBO.proc" SQL6 = SQL6 & " Where NO like '00010044%'" set rs6 = my_conn.Execute(SQL6) However, this is...

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 think this is the answer for those that are interested. In the future, maybe I'll notice an error, but so far it's working. CreateDate: DateSerial((2000+CLng(Left([EventNumber],2))),1,CLng(Mid([EventNumber],4,3)))

001 represents January 1st in the event number if that helps clear it up.

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

Thanks, but how do I narrow down the Sales.date between two dates then?

Unfortunately, I simplied what I'm doing. The report is much more complicated than just what I'm showing. I using the charts within Crystal to also perform division break-downs. If it can be done it Crystal, I'm hoping to do that. Thanks for the idea though.

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...

Convert null values did it. THANKS!

Sorry about that. Yes, left join with: Left outer join to Business.ID <-> Comment.ReferenceID No other selection criteria and no results. isnull({Comment.ReferenceID}) is in the selection criteria

lbass, thanks for taking a shot, but that didn't work. I know it's probably something simple that's escaping me.

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.