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

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.

Code:

---

Len([Intemediary])>"7"

---

Can anyone offer any suggestions?

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

vb Code:

Len([Intemediary])> 7

Just realised what I was doing wrong.

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

Code:

---

Len([Intermediary])

---

as a field on the query in its own right.

:blush:Oh, the shame. Such a basic mistake.:blush: