By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 2,606 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

date

P: n/a
hi all !

i have 2 fields in a form - a Date field & a Time field.
these 2 fields have to be combined into the one field which has date &
time.
i know there must be some code to do this.
i have tried, but it only puts the date part of it into the field.
any ideas ??
thanks
brino

Oct 3 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
brino wrote:
hi all !

i have 2 fields in a form - a Date field & a Time field.
these 2 fields have to be combined into the one field which has date &
time.
i know there must be some code to do this.
i have tried, but it only puts the date part of it into the field.
any ideas ??
thanks
brino
I created a table with 3 fields; D, T, and Combined.

I entered the dates and times for a couple of records.

I then created an Update query and combined D and T into Combined.

UPDATE Table1 SET Table1.Combined = [Table1]![D] & " " & [Table1]![T];

If you want to update your table, make a copy of it first and using the
above logic you can update all of the date and time fields to be in 1 field.

If you want to keep them separated, concatenate the two like I did above.
Oct 3 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.