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!

Count Characters

Status
Not open for further replies.
Freckles

Freckles

Technical User
May 1, 2000
138
US
How can I use a query to count how many characters (including blanks) in a field? ::) Deb Koplen
deb.koplen@verizon.com

A person can stand almost anything except a succession of ordinary days.
 
Sort by date Sort by votes
I believe Len([FieldName]) will do what you need. Maq B-)
<insert witty signature here>
 
Upvote 0 Downvote
Super! Thanks so much ::) Deb Koplen
deb.koplen@verizon.com

A person can stand almost anything except a succession of ordinary days.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mhshane
  • Locked
  • Question
Query to find keywords in description field and give count
Replies
4
Views
277
Andrzejek
Andrzejek
supportsvc
  • Locked
  • Question
Distinct Count for Unique Number of Employees in Each Month
Replies
0
Views
117
supportsvc
supportsvc
OCM
  • Locked
  • Question
count by date 1
Replies
5
Views
163
OCM
OCM
0sprey
  • Locked
  • Question
Query by Month-Year and with a Record Count Field
Replies
1
Views
134
SkipVought
S
misuser2k7
  • Locked
  • Question
Count records 2
Replies
7
Views
144
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top