Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query Criteria question

Status
Not open for further replies.

knuckelhead

Technical User
Aug 8, 2002
228
US
I have a text field with formulaID's. some are 10 digit number codes and the rest contain letter-number combination.
i want a query to get just the 10 digit number codes. EG 123004181.

should i use some kind of wildcard method? if so, what characters to get all 10 digit codes?
thanks
 
I believe I just figured it out.

I used ..... Like "######*"
on the criteria line.
Knucklehead.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top