Search results
-
1
Two text fields to single datetime field?
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... -
1
Need help in getting the logic to derive table.
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...