Count Characters in a field 1

[dawnd3]

hi All, I need to write a query that counts the characters in a field. Really I need to be able to say what I need it to do if there is just one character. So, IIF([FieldName]=1 character, then...and so on.

Thanks for any help,

Dawn

 

[SkipVought]

hi

 IIF(len([FieldName]0=1,......

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[TheAceMan1]

dawnd3 . . .

There's a typo in [blue]SkipVought's[/blue] code:

[blue]IIF(len([FieldName][COLOR=red yellow])[/color]=1, ......[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[dawnd3]

Yep, I caught that Ace and was going to comment when I said thanks to Skip. It worked perfect for what I needed. Thanks guys!