This is an easy one but I'm fairly new to this. In a query, I have the following data. If a number is six digits, I need to parse the sixth digit and that becomes a new field. If it has five or fewer digits, no record is entered into Column2. For example:
Column1 Column2
12345
54321
123456 6
12
123
987654 4
6
What simple code does it take to perform this in a query? Thanks!