I have a csv file I have imported into Access. All fields are TEXT. I need to limit the list to only records that have Alpha characters in 'Field5'. The values in 'Field5' contain a mixture of alpha/numeric characters. for example:
021577560
200812345
12201992JW
0002244
09151975AD
In the above list I want to select only records 3 & 5 (having JW or AD). Does anyone have any suggestions on this? I tried sorting the field, but that does not help. I am building a criteria field with a formula of:
like("*A*") or like ("*B*") or like ("*C*") -- but surely there's a better way..
thank you!
021577560
200812345
12201992JW
0002244
09151975AD
In the above list I want to select only records 3 & 5 (having JW or AD). Does anyone have any suggestions on this? I tried sorting the field, but that does not help. I am building a criteria field with a formula of:
like("*A*") or like ("*B*") or like ("*C*") -- but surely there's a better way..
thank you!