I'm working with a linked table and the table has a timestamp field that is in a general format ex. 4/18/2007 7:00:34 PM
I need a way through a query that I can get the timestamp field to read in a short date format so I can link this table with another that is using the short date format with no time.
Any help would be much appreciated.
Thanks in advance
I need a way through a query that I can get the timestamp field to read in a short date format so I can link this table with another that is using the short date format with no time.
Any help would be much appreciated.
Thanks in advance