Seperating Date/Time Field

A

AdminD&R

How do I separate a Date/Time Field in a query, such that
I have two separate field(s) one Date and one Time?
 
A

Allen Browne

Type these expressions into two columns of your query design grid (Field
row):

DateBit: DateValue([YourFieldNameHere])
and
TimeBit: TimeValue([YourFieldNameHere])
 
Top