format

G

galin

Hi, guys.

I am trying to format a field in my table. I have Time_Punch_in whic
is in format 900000. I'd like to convert it to be 09:00 or 9:00.

I had the same problem in Excel. I used a formula which was provide
for me to convert 90000 to 9:00. However, when I imported the Exce
fiel to Access I 've lost my formatted field.

Do you have any ideas how to fix this problem?

Thank you

Gali
 
M

Marin Kostov

Just use the same format from Excel to Access.
The formatting changes ONLY the way the data is displayed, not the actual
data.
 
Top