Search results

Hi recyan, I will try talk to the db adminstrator as i do not have rights to the db source(oracle). What i have been working on is an access view/table created from the source. I will be able to extract directly from the db source starting next week, but before that i am told to derive working...

Sorry confusing u. is it to be read as 2nd of may. data in my source table are in DD/MM/YYYY format. And both field in source table are text field. Are u able to dwnload my .mdb with the given link?

Hi recyan, After following your instructions i got back -85, 0, 31 and 85 as values for ValidData field. E.g. TheInDateTime = 30/04/2012 23:32:42 TheOutDateTime = 02/05/2012 22:44:24 returns me the value -85. TheInDateTime = 02/05/2012 18:47:46 TheOutDateTime = 01/05/2012 19:38:01 returns...

Hi recyan, I do not uds this part. Mind explain it again what should i do? i am really dumb:( Thanks for really looking into my problem. Do u want my .mdb file? Thanks, 10e5x

Hi recyan, Regarding to this, for now, to be as accurate i hope that for a particular Out time to match, it must be between than the latest IN time and the next IN time if it exits. If the next IN time does not exists, it must be between than the latest IN time and the NOW time. However if this...

Hi nanscombe, I am using at the select statement...is that possible? If yes, example? Thanks, 10e5x

Thanks for replying nanscombe, doesn't work:(

Thanks John, however will it convert to the format i want? DD/MM/YYYY HH:MM:SS?

I was search for the solution for this but realize many of the solutions found are not applicable to ms access 2003. I have two fields namely Event_D: 30/04/2012 and Event_T: 22:01:18 Both are text data type. How can i combine this two into a single datetime field Event_DT: 30/04/2012 22:01:18...

To all who have replied, Thanks so much for your efforts and input. I am not allowed to upload the .mdb file(company policy), but for my own sake and for the ones who wanted to help, i extracted a sample of 20k data from the source and put it in Excel. I hope u all can open that and load it...

Hi reycan, I would like to thank you for your effort. I think have to use the second option. Do you mind showing your option 2 solution. I have done something similar to the first option before, will have bugs like getting negative working hours. And just another qns, i need the date and time...

Hi i cant see any code after opening the FindTime form. Anyway greatly appreciated u tried to help.

Hi JohnLee, I have got an idea, but need your help in generating the sql statements. Firstly convert EventDate + EventTime into single datetime field(EventDT) with the format (DD/MM/YYYY HH:MM:SS). From the raw data, we could split it into 2 tables: Entry and Exit with values gathered by using...

Hi John, haha not the john. Firstly thanks for replying. Glad at least someone attempted. As for your qns, the john and other staff is the same person throughout. John may not have a clock out on 21st its becuz the data i working on is a sample data where data is extracted is for a datetime...

Hi all, I am faced with a very troubled scenario. I am given a .mdb from access 2003. The data are so messy and i am tasked to derive the working hrs. TACS table: EventDate StaffName EventTime Message 21/11/12 John 23:01:00 OUT 21/11/12 Peter 23:10:00 IN 21/11/12 Peter 23:10:05 IN 22/11/12...