string function?

R

r

Is there a string function that will allow me to, for example, pull
positions 5 through 20 of a particular field in a table - I'd prefer to do
it in a query. Is possible?
 
F

fredg

Is there a string function that will allow me to, for example, pull
positions 5 through 20 of a particular field in a table - I'd prefer to do
it in a query. Is possible?
Click to expand...

NewColumn:Mid([FieldName],5,16)

will return 16 characters starting at position #5.
 
R

r

THANK YOU! I've been digging through stuff on the web with no luck...
very much appreciated!


fredg said:
Is there a string function that will allow me to, for example, pull
positions 5 through 20 of a particular field in a table - I'd prefer to do
it in a query. Is possible?
Click to expand...

NewColumn:Mid([FieldName],5,16)

will return 16 characters starting at position #5.
Click to expand...
 
Top