1 of 1 people found this helpful
try this if ASCII( left([Code],1))>=65 then "Letter" else "Number" end
Ascii codes for letters start at 65 - numbers are 0-9
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Could you please attach a sample data so that it would be helpful to solve the problem.
I think this is the solution I was looking for!
Thank you very much!
Glad to help out