Hey so I'm working with some tables from an SQL server and I can't change the format but I need to be able to read it and store it.
Currently it stores the time like "10.83973". That is an example pulled from the table. In excel I can convert it to 8:09:13PM but I need to know how to do it in Access and how to reverse it so I can store the current time as well.
Access says it is a short text field and I do not have access to the SQL database easily (I would have to ask my boss to get whatever info I needed and he is usually very busy)
So basically I am looking to understand and be able to convert 10.83973 to 8:09:13PM in Access/VBA (Assuming that is correctly converted which it seemed to be)
Appreciate the help and apologies for weird wording, I wasn't sure how to explain it really.