Need function for selecting a specific position of a recod


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.
Who is Participating?
Lee SavidgeCommented:
Does Access have a substr() function or a sustring() function. Mid() may do it as well.

jdallainAuthor Commented:
Thanks Lee, I was using Mid but I didn't have anything after the second comma. Duh!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.