Search results for query: *

Thanks for the link. However, I'm not having trouble with alternating row colours, it's the highlighting rows in which the values don't match up that I'm having difficulty with... -Skye

I have an 2d array with values in it. The basic structure for each row in the table is: Name | Detail 1a |Detail 2a | Detail 1b | Detail 2b... I want to compare all the detail 1's with each other and then all the Detail 2's with each other. If any of the compared details do not match, I want...

hmmm... nothing in my new column... sigh...

This works: sql = "UPDATE PRSUDataAll SET FIRSTAPPDATE =" & Left(APPDATE, 4) & "/" & Mid(APPDATE, 5, 2) & "/" & Right(APPDATE, 2)& FIRSTAPP //cn.Execute sql I'm not sure why the // is in front of the Execute statement, but so far, no errors... I guess I'll find...

I get "expected end of statement" sql = "UPDATE PRSUDataAll SET FIRSTAPPDATE = Left(APPDATE, 4) & "/" & Mid(APPDATE, 5, 2) & "/" & Right(APPDATE, 2) & " "[here] & FIRSTAPP & ";" ... should I be using any single quotes? Thanks for your...

Well, when I put the space and " in, I get a message saying there's an unterminated string constant at the end. So I tried to put a " at the end of the sql statement and it says that there's an expected end of statement after the " which is after the space...

Thanks for your help, but I'm still having some trouble. I wrote this sql statement: sql = "UPDATE PRSUDataAll SET FIRSTAPPDATE = Left(APPDATE, 4) & "/" & Mid(APPDATE, 5, 2) & "/" & Right(APPDATE, 2) & " & FIRSTAPP cn.Execute sql where FIRTAPPDATE is my new...

OK, let's just forget I said anything... I'm going off on some tangent that you people probably don't need to be bothered about... Sorry...

Ok, I'm thinking of doing something like this... sql = "UPDATE PRSUDataAll SET APPDATE = Mid(APPDATE, 1, 4) & "/" & Mid(APPDATE, 5, 6) & "/" cn.Execute sql sql = "UPDATE PRSUDataAll SET APPDATE = SET FIRSTAPP & SET APPDATE" cn.Execute sql where APPDATE...

Can you update the fields through a sql statement? I would like to change a yyyymmdd into a mm/dd/yyyy. Once that's done, I need to combine this column with a time column so it becomes a date time column... can it be done in sql? or do I need to create a new column first. Thanks! Tell...