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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
USe the MID function in a new field to pull the part you want.

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

for example.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

crosstab or pivottable or ? 1
Help! 1
Using a wildcard in a QUERY 4
Input mask on my report! 4
Changing values 1
Separate field into multiple records 13
Query help for "like" 1
Query Question? 3

Back
Top