In query writing...getting only the data you need

A

amandakmartin

I am trying to gather info and I only need part of the field for my report.
The field looks like SP: 12345: GG: TO

I do I get in the criteria - only the 12345 part of the field? Any help
would be greatful!!

Thanks.
 
R

Rick B

USe the MID function in a new field to pull the part you want.

NewFieldName: Mid([currentfieldname],6,5)

for example.
 
Top