I have two fields in a Microsoft Access Database called TicketNbrDate (Date/Time - Short Date -mm/dd/yyyy 11/01/2019) and TicketNbrTime (Date/Time – Medium Time 4:00 PM). I have created a query in which I have created two new fields based on the first two field called TicketNbrDateConv (Date/Time – Short Date but in the format yyyymmdd 2091101) and TicketNbrTimeConv (Date/Time – Medium Time but in the military time format 1600.
I would like to combine the two fields TicketNbrDateConv and TicketNbrTimeConv into a single field which would look like yyyymmdd-xxxxxx. Where the xxxxxx would represent the military time without the colon and with a preceding zero for single digit hours. This would give me a way of sorting the records in date time order.
How would I create this field?
There is probably an easier of way of doing this but being an amateur Access person I am not sure how to do this.
There may be a way to have this information entered into a single field where the person would enter the date in the format mm/dd/yyyy hh:mm AM or PM.
Any thoughts.