I have a problem in Access. I am trying to take the data from one column (UniqName), which is a number and and take the first three digits from that number and place it in another column.
I know that I need to declare UniqName a string in order to use the command to take those numbers.
I also now that the built in function to take the first three numbers is:
Left([String], 3)
What I don’t know is where and how I declare the string. I need to be walked through this process, step by step.
Please help ASAP
