Seperating Date/Time Field

  • Thread starter Thread starter AdminD&R
  • Start date Start date
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?
 
Type these expressions into two columns of your query design grid (Field
row):

DateBit: DateValue([YourFieldNameHere])
and
TimeBit: TimeValue([YourFieldNameHere])
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I create a date from data in seperate columns 2
Convert Date and Time 9
date & time question 7
Updating tables when you input new data 0
Access query 7
time conversion from text 3
Count and sum per month in a query 2
Date and Time 1

Back
Top