Recent content by kohbengleong

Hi Bob, As i am a total noob in access, please kindly advise how do i go about using the code? Do i paste it in Macro or Modue? I am currently using access 2003 on windows XP. Many thanks!

Hi Anyone who can help me, I need to have a field that returns the difference between the [Closed Date and Time] and the [Created Date and Time]. Then the difference will be in the format of hhhh:nn:ss. That means if the difference is more then 1000hours it will show in hours, mins and secs...