Access 2010 combining date and time fields in a table.

[PS1991]

Hi,

I have a table that has a date field (Date/Time dd-mmm-yy) and a time field (Date/Time Short Time).

Is there a way that I can create a new field in the table which combines the two fields into a DateTime field?

Or can this only be done through a query?

Thanks​

 

[accessAnswer]

Hey,

I think the proposed a good solution in this thread:
http://www.access-programmers.co.uk/forums/showthread.php?t=99191

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
visit msaccess2010.com - tutorials, bugs, fixes,errors and q & a