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!

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

Character Criteria 1

Status
Not open for further replies.
hdat44

hdat44

Technical User
Aug 15, 2002
50
GB
i have another problem using criteria, i need to dispaly records that are only 6 characters long, these are a mix of random numbers and letters. i tried Like ###### but this only gave me the records that had 6 nubers and i need a mix. any help welcome.
 
Sort by date Sort by votes
Like '??????'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TrekBiker
  • Locked
  • Question
Select addresses using two criteria, one 'Like" 2
Replies
3
Views
285
TrekBiker
TrekBiker
qqp
  • Locked
  • Question
Query criteria from form
Replies
9
Views
343
qqp
qqp
Aximboy
  • Locked
  • Question
carry previous data within a criteria
Replies
3
Views
152
dhookom
dhookom
Matt K
  • Locked
  • Question
Access left join on multiple criteria question
Replies
0
Views
88
Matt K
Matt K
misuser2k7
  • Locked
  • Question
Multiple criteria in query 2
Replies
5
Views
130
misuser2k7
misuser2k7

Part and Inventory Search

Sponsor

Back
Top