I am taking three fields (Time, Date, Number) and putting them together as a bar code (that I can do). When the bar code is scanned I want to split the data again. I assume using LEFT RIGHT MID would be the way to do that however, it seems you need to know exactly how many characters are in each field.
How can I be sure that the fields are consistent length? For instance: Date of 4/2/19 needs to always be 04/02/19. Time of 7:05 needs to be 07:05, Number needs to be 002 or 128 (up to three characters). So the three fields together would be 04/02/1907:05002.
Is there a better way to split the data out of the bar code? Without five pages of coding?
Access 2016