I want to parse, select and display in a combo box only entries that are DISTINCT at mid([Serial Number],6,2).
The field [serial numbers] is of the form
where X is a letter, NN is a sequential number and YY is the two digit year.
The field [serial numbers] contains other random data that does not matter.
The table that [serial numbers] comes from is [all].
The combo box would then ideally look like:
How do I do this with an SQL statement.