Date Format

[DBFIN]

I have two separate fields that contain a date and time.

Entrdate Timestamp
1/8/2014 10:12am
1/20/2014 8:33am

How can I convert these two fields into a single field with normal long date format like 01/08/2014 10:12 AM ?

 

[bob fitz]

You could concatenate the two fields in a query with:
NewField: CDate([DateField] & " " & [TimeField])

 

[DBFIN]

thanks, perfect