Thank you for your assistance!

Excuse me for my ignorance with Access and VBA, but how can I apply
this in Access? I have a table that has times like 3098739942 and want
to have it converted during the query so that the new table has correct
time values.

Do I make a small module with the command you gave me and call it
during the query, or something??

Thanks again!!


--
smpayne69
------------------------------------------------------------------------
smpayne69's Profile: http://www.excelforum.com/member.php...o&userid=29307
View this thread: http://www.excelforum.com/showthread...hreadid=490251