format

  • Thread starter Thread starter galin
  • Start date Start date
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
 
Just use the same format from Excel to Access.
The formatting changes ONLY the way the data is displayed, not the actual
data.
 
Back
Top