counting char in a field

Webhead211 · 07-12-2001, 07:30 AM

Sorry to bother you all again, but you've been so helpful i just had one mroe question. Does anyone know the command to count the numberof characters in a field? I want my query to display only entries with 35+ characters. i tried looking into count.. but that only seems to count the number of fields, not characters within the field

Thanks Again,

Webhead211
"I run faster than the speed of light"

ironchef · 07-12-2001, 08:51 AM

pssst... what language are we speaking in, here?

Webhead211 · 07-12-2001, 09:22 AM

Um.. i'm using microsoft access 2000.. so whatever language the query box uses. an example of code i've used before it is the Immediate if statement =IIf(IsNull[field], 1,2]) hope that helps.

Webhead211
"I've got a fever.. and the only prescription for it... is more cow bell!"

ironchef · 07-12-2001, 09:42 AM

SELECT *
FROM table
WHERE len(FieldToBeCounted) > 35

that oughta do it. i never use access's query builder cause it's just too cumbersome for me to figure out, so i don't know what this looks like in that.

Webhead211 · 07-12-2001, 09:59 AM

I'm a moron. D'oh... length. sigh... thanks a million. Thats exactly what i needed.

Webhead211
"Beware of the Penguins"

07-12-2001, 08:51 AM	#2
ironchef Commander Join Date: Dec 2000 Location: SF Bay Area Posts: 1,342	pssst... what language are we speaking in, here? __________________ blurt blurt blurt

07-12-2001, 09:22 AM	#3
Webhead211 Lieutenant Junior Grade Join Date: Mar 2001 Location: Mass Posts: 54	Language.. Um.. i'm using microsoft access 2000.. so whatever language the query box uses. an example of code i've used before it is the Immediate if statement =IIf(IsNull[field], 1,2]) hope that helps. Webhead211 "I've got a fever.. and the only prescription for it... is more cow bell!"

07-12-2001, 09:59 AM	#5
Webhead211 Lieutenant Junior Grade Join Date: Mar 2001 Location: Mass Posts: 54	Thanks! I'm a moron. D'oh... length. sigh... thanks a million. Thats exactly what i needed. Webhead211 "Beware of the Penguins"

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

07-12-2001, 07:30 AM	#1
Webhead211 Lieutenant Junior Grade Join Date: Mar 2001 Location: Mass Posts: 54	Sorry to bother you all again, but you've been so helpful i just had one mroe question. Does anyone know the command to count the numberof characters in a field? I want my query to display only entries with 35+ characters. i tried looking into count.. but that only seems to count the number of fields, not characters within the field Thanks Again, Webhead211 "I run faster than the speed of light"

07-12-2001, 09:42 AM	#4
ironchef Commander Join Date: Dec 2000 Location: SF Bay Area Posts: 1,342	SELECT * FROM table WHERE len(FieldToBeCounted) > 35 that oughta do it. i never use access's query builder cause it's just too cumbersome for me to figure out, so i don't know what this looks like in that.

User Name
Password
Remember Me?