Search results

@Gasman @cheekybuddha Awesome help and thanks for explaining it. That was exactly what I needed and the code shared got it working. You all rock!

Hi, I am converting what I believe is T-SQL into MySQL. I have done pretty good so far but I ran into this and needed some help explaining this part of the query: SELECT tblStratProfile.ProfileNum, tlkpProfileView.ProfViewDesc, IIf((IsNumeric([tblStrat]![StratNum])),[tlkpSUTyp]![SUTyp] & ' '...

@Pat Hartman Thanks for moving this. I am new here and didn't even realize there was a forum for these questions. Thank you all for your responses and help!! From the information you all provided I was able to come up with this for my WHERE which worked: WHERE tablename like 'tblPD' AND...

Hi, I am pretty new to T-SQL but I have this on an old ASP page: sqlDataDict = "SELECT tblDataDict.TableName, tblDataDict.FieldName, tblDataDict.Description" sqlDataDict = sqlDataDict & " FROM tblDataDict" And then down the page there are a bunch of these, each one requesting different data...

Hi, Thank you all for your response. I had eventually assumed it was for a collection, but it still didn't make sense because there is only a single value in the URL. This is part of the statement where it is included: SELECT tblPhotoManage.Date, tblPhotoSU.RecordCounter, tblPhotoSU.Site...

Hi, I am new to access and I am trying to update a site I have inherited. There is an SQL statement in an ASP page that is requesting data from the URL: & Request("SUNum")(1) & This is in the URL: &SUNum=110& I am not understanding what the (1) is for. It is probably really common I am...

@The_Doc_Man This is extremely kind and awesome of you to take the time to explain it in a way I can understand! I'll re-read it a few times so it all can sink in but this has been incredibly helpful!! Thank you all for your great explanation and taking the time to help me understand what this...

Thank you all so much!! This has been extremely helpful for me being new to all of this. One thing, the '!' and '.', it is simply being used because it is being used in control or form? In my case it is a form that is referencing the statement. Do they have any other meaning? CDbl -...

HI, I am trying to work with an access 2007 database and update a website. I have a bunch of queries I need to interpret and bring them up to date. Can someone please tell me what this means: CDbl(IIf(IsNumeric( [tblSU]![SUNum]),[tblSU]![SUNum], Left([tblSU]![SUNum]...