I am having trouble getting the proper format in a field where I would like to track the date and time that is inputted into my inventory tracking database. It is ONLY recording the date that I inputs into the database. In the table titled, replacement event, I have 6 fields that have the data type of date/time. In each of them the format is General Date. I would like to be able to record the date AND time but it only records the date Can anyone help me figure out how to display the time AND the date?
Attached are pics of my in design and datasheet view. Let me know if you need anymore pics.
Thanks