I have a column that contains data in the following format: 2007-10-19 14:36:00. I would like to split the data into 3 new separate columns for year, month and day. I have no need for the military time stamp info. Is there a query that could accomplish this?

---

Answer from Richard Rost:

Is this data currently in a TEXT field or in a DATE/TIME field. How you handle this is important. If it's a DateTime field, you can just use the Month(), Day(), and Year() functions to break it apart. If it's currently a TEXT field, then you'll have to use string manipulation functions to break it apart (Left, Mid, Right, etc.) which is a little more involved. Let me know what kind of data it currently is and I can help you further.