Likely a simple solution for this.
I have a table called “Event” where the primary field is pulling the date from a secondary field called “EventDate”, adding a number from a field called “OrderInDay”, and then adding an autonumber from a field calle...