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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

searching for upper case 2

Status
Not open for further replies.
gusset

gusset

Technical User
Mar 19, 2002
251
0
0
GB
please can someone remind me how to search in a query for records starting with an upper case character?

thanks

gusset
 
Sort by date Sort by votes
You could find the ASC(Left([YourField],1)) and compare it with the ASC() values of A - Z
Between ASC("A") AND ASC("Z")

Duane
MS Access MVP
Find out how to get great answers faq219-2884.
 
Upvote 0 Downvote
many thanks, dhookom

gusset
 
Upvote 0 Downvote
Criteria Like below:

Asc(Left([Your field],1)) Between "65" And "91"

ChaZ
 
Upvote 0 Downvote
...and also to you, blorf
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

datajockey123
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
143
dhookom
dhookom
JK Dutta
  • Locked
  • Question
requet for form an access query for report
Replies
2
Views
168
dhookom
dhookom
monkeysee
  • Locked
  • Question
Select Query for append query 1
Replies
12
Views
151
monkeysee
monkeysee
SoLost1
  • Locked
  • Question
Please Help for Passing Multiple Select ListBox Values as Parameter for WHERE IN clause of Query
Replies
3
Views
80
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Can not get Access 2016 queries to accept form value input or TempVars! input 2
2
Replies
21
Views
211
TheresAlwaysAWay
TheresAlwaysAWay

Part and Inventory Search

Sponsor

Back
Top