A AdminD&R Oct 15, 2003 #1 How do I separate a Date/Time Field in a query, such that I have two separate field(s) one Date and one Time?
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 Oct 15, 2003 #2 Type these expressions into two columns of your query design grid (Field row): DateBit: DateValue([YourFieldNameHere]) and TimeBit: TimeValue([YourFieldNameHere])
Type these expressions into two columns of your query design grid (Field row): DateBit: DateValue([YourFieldNameHere]) and TimeBit: TimeValue([YourFieldNameHere])
