[RESOLVED] [Access 2003] Query Build Expression - Length

[Torc]

I have a query which has a number of fields one of which is called Intemediary.
This field is a string, I need to place a criteria on the query so that only
those rows where Intemediary is longer than 7 characters are returned.

Unfiortunately all I have been able to create using the Build Expression is the
following, which does not work.

Len([Intemediary])>"7"

Can anyone offer any suggestions?

[NeedSomeAnswers]

surely you shouldn't be wrapping your number 7 in quotes. As far as I am aware the Len command does work in Access.

Len([Intemediary])> 7

[Torc]

Just realised what I was doing wrong.

I was writing the expression in the Criteria field for Intermediary in my query,
instead of adding

Len([Intermediary])

as a field on the query in its own right.

Oh, the shame. Such a basic mistake.