Recent content by ynott

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!