Separating data within a table (1 Viewer)

[powellk]

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

 

[MarkK]

Check out the DateValue() and TimeValue() functions, which take a Date/Time variable and return only the date portion, or time portion, as the case may be.
Cheers,
Mark

 

[powellk]

Brilliant, it took a little while working out how to use the DateValue and TimeValue expressions within my query but it works very well. It has separated out the date and time without impacting on the table data.

Many thanks for your help.