Search results for query: *

Hi Clarkin, That error is kind of accepted. Let say that they first add a check and record as problemID 1. Next time they go back to edit the record and record there is no ProblemID 1 anymore. However, they later found out that they made a mistake last time and ago and record the ProblemID...

Hi Clarkin, It works except for 1 exceptional case that related to human input error, but I can't delete record - I have to consider as a normal case. The problem is for example updateNo 1 has ProblemID 1, updateNo 2 doesn't have ProblemID 1, updateNo 3 has ProblemID 1 again. In this case...

Hi Clarkin, I can't get UpdateNo = T.UpdateNo - 1 since there can be as many more updated batches before the time stamp of the record that I want to pull out. I am still working on it right now and the weekend. Please let me know if you have any suggestions for me. According to the table...

Hi Clarkin, Yes :) I enjoy it. There is one more step that happens is that if the ProblemID of record ID #1 now is ProblemID #5 instead of ProblemID #1, but I still have to pull out TimeStamp of record ID #8 because I have to pull out an update batch after the batch that has ProblemID #1...

Hi Clarkin, Yes, you are right! what you are assuming are the things that I need to do as: "for each checkno, the TimeStamp column of the earliest update batch where there is no problemid=1 in the batch Is that right? (also i'm assuming that TimeStamp column is actually of type...

Can anyone help me real quick, please? Thanks in advance. I have a table that contains all update history of every single check. Within each check, I need to pull out the TimeStamp of a update batch (regardless of stage) WHEN the ProblemID #1 is not included in that batch anymore. In the...

I am sorry Rick, my mistake. Thanks Rick and Tony!

Hi Rick, I don't know why I got a run-time error, it said that "Undefined function 'Value' in expression". Btw, I am using xp version. The dataType of the column is varchar.

Can anyone please help me out with this: LoanInfo table: LoanNum 1A 2A 3A 4A 5A 6A 7A 8A 9A 10A I want to get the maximum number (which is 10) in the table so I can increase 1 unit for the next LoanNum (11A). I have a sql statement works in sql database but when I use CInt, it doesn't work...

Hi ClaireHsu, It's still from 01 to 06. However, don't worry, I will try to work on it and will see. For now, I can update 1 state at a time is ok with me. Thank you so much for your help.

Hi ClaireHsu, I will try tomorrow at work to see how it come out. This is my table created by your code: ManagerID State Hireddate 10 AR 1/1/00 11 AR 1/20/02 12 AR 1/22/00 13 CA 1/2/02 14 CA 1/4/02 15...

Hi ClaireHsu, I just did as you said again, but the result is still from 01 to 06. Can you help me check back the code with me? I haven't got it yet. Thanks a lot for your big help and your valuable time!!!

hi ClaireHsu, No I didn't change anything. I rerun the stored procedure and still got: 01 for ManagerID 10 05 for ManagerID 11 02 for ManagerID 12 03 for ManagerID 13 04 for ManagerID 14 06 for ManagerID 15

After running to stored procedure, I got NewID from 01 to 06. However, I need to get NewID from 01 to 03 for AR state and from 01 to 03 again for CA state. Can I get help another time? Thanks,

Hi everyone, Please help. I need to update my NewMgrID in tblManager table. What I need to do is group the records in tblManager by State, then within each State, sort them by HiredDate in ascending order. I have to update the NewMgrID starting with the record that has a smallest HiredDate...

Hi Gol4, Yes, I got it as your suggestion that I have to count in the select statement. Thanks a lot for your help!

Hi all, Please help me how to count records when opening a recordset. I want to know if CA is in my State field already of tblManager table. Function ForCount() Dim rs As New ADODB.Recordset Set rs = New ADODB.Recordset rs.Open "Select * From tblManager&quot...

Hi John, I almost got it. I need to set the NewMgrID = tblState.LocationID + Autonumber (Not MangerID). The Autonumber should be always 2 digits. e.g. 01, 02,...10, 11 let say for State CA and repeats for state AR as 01 again. The order of this autonumber must be base on HiredDate of each...

Hello, I am look for help. I have 2 tables: tblState and tblManager. The tblState table has 2 varchar fields as followed: State LocationID ===== ========== AR 012 CA 015 The tblManager table has the following fields: ManagerID LName FName State HiredDate 1...

Happy New Year to Everyone!!! I have a problem that needs your help please. I need to count how many business days between a StartDate and EndDate. This is the example that I have been trying to figure it out. I need to count number of business days between 9/18/2002 and 12/31/2002...