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 derfloh 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
Joined
Aug 15, 2002
Messages
50
Location
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 Question
Select addresses using two criteria, one 'Like"
Replies
3
Views
647
TrekBiker
TrekBiker
qqp
  • Locked
  • Question Question
Query criteria from form
Replies
9
Views
718
qqp
qqp
Aximboy
  • Locked
  • Question Question
carry previous data within a criteria
Replies
3
Views
365
dhookom
dhookom
Matt K
  • Locked
  • Question Question
Access left join on multiple criteria question
Replies
0
Views
240
Matt K
Matt K
misuser2k7
  • Locked
  • Question Question
Multiple criteria in query
Replies
5
Views
360
misuser2k7
misuser2k7

Part and Inventory Search

Sponsor

Back
Top