|
-
Sep 18th, 2008, 09:13 AM
#1
Thread Starter
Hyperactive Member
[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?
Signature Under Construction 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|