Martin Caro
mcaro at bigpond.net.au
Mon Jul 19 06:29:52 CDT 2004
Hi Folks I have spent some time in the archives and reviewing past date/time issues looking for a fix for this problem: I grab the user login time using NOW() and save it to an SQL table however any seconds apparent in Access always end up as :00 being save in my SQL table. I was using smalldatetime data type which I changed to datetime but without success. I have played with Format() a bit but maybe someone knows where my seconds have gone? Martin