From: Cactus on 13 May 2010 10:58 VBA can handle time to the millisecond but the native functions ignore this. Here's how to deal with milliseconds including revised versions of all the native date/time functions of VBA: 'MS Access Can Handle Millisecond Time Values--Really' (http://www.devx.com/dbzone/Article/39046/1954) /gustav -- Cactus ------------------------------------------------------------------------ Cactus's Profile: http://www.thecodecage.com/forumz/member.php?u=1856 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=187507 http://www.thecodecage.com/forumz |