Hi,
Surprise, surprise, I'm new to this forum, and have a million silly questions. But I shall start at the beginning.
I have imported some data with around 10 coulmns. In one of these columns is the date/time. I need to separate this information, and enable me to append my existing table. Previously, I would export to excel and run a text to column.
But I don't want to do that. I want to run it in Access. I did notice a function called DATEPART. However, not too sure if this is the correct function for my requirement.
Help !!!
Many thanks
Powellk
Surprise, surprise, I'm new to this forum, and have a million silly questions. But I shall start at the beginning.
I have imported some data with around 10 coulmns. In one of these columns is the date/time. I need to separate this information, and enable me to append my existing table. Previously, I would export to excel and run a text to column.
But I don't want to do that. I want to run it in Access. I did notice a function called DATEPART. However, not too sure if this is the correct function for my requirement.
Help !!!
Many thanks
Powellk