Home > IT Answers > Database > Changing field format in Access 2003
Britinga
425 pts.
 Changing field format in Access 2003
Access 2003, Microsoft Access, Microsoft Access forms
We have an Access data base that includes date of birth in the format mm/dd/yyyy.
For reasons I don't need to go into now, we have to change all of them to a different format - yyyymmdd. Is there a way of doing this without changing every individual record?
This would save us hours of work.
Thanks
ASKED: Jan 28, 2009  8:23 PM GMT
UPDATED: January 28, 2009  11:09:03 PM GMT
RELATED QUESTIONS
Britinga
425 pts.
Answer Wiki:
Last Wiki Answer Submitted:  Jan 28, 2009  8:23 PM (GMT)  by  Britinga   425 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

Is that field in Date/Time format or Text format?

Mshen
 26,465 pts.