I have an Mysql database and have linked some tables via odbc to an access database.
When i open the tables in access i have some fields that should have a time format, like a phonecalls conect time.
But the strange (for me) is the format of the time in my access table, the format is like this xxxx-xx-xx.
as an example the time 11:56 comes out like: 2015-07-05
Does anyone know how to get the format like xx-xx-xx
best regards
When i open the tables in access i have some fields that should have a time format, like a phonecalls conect time.
But the strange (for me) is the format of the time in my access table, the format is like this xxxx-xx-xx.
as an example the time 11:56 comes out like: 2015-07-05
Does anyone know how to get the format like xx-xx-xx
best regards