derekstewart
MIS
I have a department description and the its corresponding number on the same line. I would like to remove the number, which always takes up the last 7 spaces in the description. I tried right(department,7)...and was left with the numbers, not the description w/o the numbers. Can't remember the right function for access 97. Any help would be greatly appreciated