Hello all. I am in the process of converting all of our queries at my job from an old Access DB (97) to Access 2016. Even though this query is very simple, combining employee punches with employee name, there is a difference in the data I get between old and new. This is what is happening:
--------------------Clock In---------------------Clock Out
Access 97 --------05:30:36 AM ---------------03:27:25 PM
Access 2016 -----07/17/19 05:30:36 AM ----07/17/19 03:27:25 PM
For some reason, on the TIME fields, Access is putting in the date the report was run in front of it. So yesterday it was 07/16/19 even though the date range I am running the data was the 15th on both days. Having looked at the table format, it is Date/Time, but the source data (our manufacturing ERP system) does not have a date inside of a time field. I have searched extensively online and couldn't find anything. I would like to know how I can get rid of the date and just have the time as a result in the query export. I am using design view btw. I have little experience with SQL but am willing to try if thats the only way to solve this. I am also trying to avoid formatting after exporting to Excel.
Please help!!
Edit: Sorry for the dashes in the little table I made, all the spaces I put in didn't stick when it was posted.