View Full Version : Solved: String Length

05-08-2008, 06:23 AM
First of all, I'm working with SQL in MS Access.

I need to evaluate the length of a string, and I'm not sure how to do that. I'm evaluating a field named AcctNmbr which is a text value.

It's for a pivot table I'm building- all of the records in AcctNmbr are either 10 character length or 14 character length. The length will be used as part of an iif expression that will change the name of the row heading in a crosstab query.

05-08-2008, 08:26 AM
IIf(Len([AcctNmbr]) = 10, "Result if true", "Result if false")

05-08-2008, 12:53 PM
Thanks :)