I (stupidly) was using a DateField and a TimeField instead of just 1 date/time field. There are thousands of records so I don't want to have to combine these by hand. I have hardly used access, I generally just call database query's from vb.net. Is there anyway inside access to merge these 2 fields (ie put the date from the date field and the time from the time field into a new "combined" date/time field?



Thanks!

Dave