hi all. i'm just begining to learn VBA, therefore i've got this question regarding Access and the use of VBA to automate conversions of numbers into time. my test db contains a column that is in a number format but stands for a 24-hr time value (i.e. 233537 means 23:35:37 or 9 means 9AM but without the 09:00:00). however, i need to make this number into the 24 hr format but to MS Access, this number is simply a number and can't be formatted into a time value (esp. without a delimtter). i got a data dump in a form of a text file and imported it into Access (it contains 1.5 million recs). i don't know how to write an SQL query to do this, so i want o automate the process so that in future i can simply run the VBA process after i've imported the data dump into Access. if anyone can help me or direct me to some resources, that would allow me to convert these numbers into a time format that takes into account numbers that are like 233543 and 9 . i thank you in advance for any help and wish you good things. thanks.
RG