date and time separtion

J

Jay

Table has a field with Date/Time data type ( 09/08/2005 21:45:35 format).
I need to separate its Date and Time portions into two fields (Date Field
and Time Field). How Can I do that? Later I need to combine them again. How
Can I?
Use function or another query? Thank you. Really appreciate your help.
 
D

Douglas J. Steele

Further to what Joseph's suggested, create a query that has all of the
fields of your table, plus two computed fields: one for the date portion of
the field, and one for the time portion of the field. To extract only the
date, you use the DateValue function, while to extract only the time, you
use the TimeValue function.

Use this query wherever you would otherwise have used the table.
 
Top