jdallain
asked on
Need function for selecting a specific position of a recod
Experts,
I can't remember or find the function that gives you a specific positional value from a record. For instance, if i have a field that returns the record 2 7/8, then I can get the position of 7, which is 3, by using this funcation: Instr(field,"/")-1. However, I can't isolate the 7 by using a using a function to find the value at position 3.
I can't remember or find the function that gives you a specific positional value from a record. For instance, if i have a field that returns the record 2 7/8, then I can get the position of 7, which is 3, by using this funcation: Instr(field,"/")-1. However, I can't isolate the 7 by using a using a function to find the value at position 3.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Lee, I was using Mid but I didn't have anything after the second comma. Duh!
James
James
Lee