How to unconcatenate a record in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with a fields that contains both a date and time. I am having
trouble pulling a query using a Between (this) And (That) criteria. Can I do
something like I can in Excel where I can seperate the two pieces into two
seperate fields?
 
I have a table with a fields that contains both a date and time. I am having
trouble pulling a query using a Between (this) And (That) criteria. Can I do
something like I can in Excel where I can seperate the two pieces into two
seperate fields?
Click to expand...

The functions DateValue() and TimeValue() will extract the date and time
portions respectively.

Another trick (if you're missing records from the last day) is to use a
parameter query:
= [Enter start date:] AND < DateAdd("d", 1, [Enter end date:])
Click to expand...

to include all records before midnight at the end of the parameter date.

John W. Vinson [MVP]
 
--
Bill1967


John W. Vinson said:
I have a table with a fields that contains both a date and time. I am having
trouble pulling a query using a Between (this) And (That) criteria. Can I do
something like I can in Excel where I can seperate the two pieces into two
seperate fields?
Click to expand...

The functions DateValue() and TimeValue() will extract the date and time
portions respectively.

Another trick (if you're missing records from the last day) is to use a
parameter query:
= [Enter start date:] AND < DateAdd("d", 1, [Enter end date:])
Click to expand...

to include all records before midnight at the end of the parameter date.

John W. Vinson [MVP]
Click to expand...
Thank you I will give this a try and see if it works for me.
 
Back
Top