Competent Performer
Windows 7 64bit 
Access 2010 64bit
Hi
How do you merge two columns together, one is the date, and another is the time.
date column as this 9/21/13
time column as this 11:01:00 am
the reason why I want to merge it is because so I don't have to retype and I would have both the date and time in one filed.
Date and time column are both Date/Time type.
Thank you!!!
Who is John Galt?
Windows XP Access 2007
Sometimes Helpful
Windows XP Access 2003
How did the data get input to the table? Maybe the time is in the date field or the date is in the time field.
You can check by opening your table and copying one of the values. Then you can paste it into an unbound textbox in a test form. Just format the textbox to show the date and time first.
Competent Performer
Windows 7 64bit Access 2010 64bit
It is enter manually. The date and time field is data type Date/Time. I see it as this when I go to design view.Originally Posted by ItsMe
Why do this? I only want a easy way to put these two together, where one field has date and the other has time. I am doing it by retyping it over. ButYou can check by opening your table and copying one of the values. Then you can paste it into an unbound textbox in a test form. Just format the textbox to show the date and time first.
is there are quicker way. For example in excel, if you want to concatenate two values together CONCATENATE (text1,text2,...)
Competent Performer
Windows 7 64bit Access 2010 64bit
This is not a manipulated table (query) it is a table that is inputted, no SQL code involved in the creation of this table.
Sometimes Helpful
Windows XP Access 2003
Because in tables with date/time fields that get the field updated using the now function often have the date and time stored in the field, regardless if the field is format long date, short time, etc. At least that is how it is in 2003. I thought it was worth a shot.
I suppose it would have been easier for me to ask you to adjust the date and time columns really really wide and click inside the different fields. Sorry about that. I tried to avoid adjusting tables if at all possible as a habit.
Who is John Galt?
Windows XP Access 2007
So use an update query to update one of those or a third field...by adding them together.
Return sum column based on another column Where statement date minus x months
Posting Permissions
Reply With Quote