I was putting the criteria Len([address])>33 below in the criteria
row of the [address] column for the query. Access was automatically
enclosing the 33 in " ".
I went into the SQL view and changed it to remove the " " enclosure
and in design view, I got a different look. It made a separate
column with the criteria Len([address]) shown as the field name and
below it on the criteria row >33 (no " " enclosure).
That did the trick. I'm not sure I understand this in Access design
view but I do understand it in SQL.
Thanks for your tips.
Regards,
Patrick Briggs
--- In [email protected], Dennis Jensen
<[EMAIL PROTECTED]> wrote:
>
> In case the "" were just a typo in the email and you
> still have the problem then I'd suggest the following:
>
> Len(Trim([address] & " ")) > 33
>
> The addition of the " " is to prevent the Trim
> function from crapping out if the value of [address]
> is Null.
>
> --- "Jacobs, Martien" <[EMAIL PROTECTED]> wrote:
> > The result of the Len function is a numeric value.
> > Use Len([adress]) > 33 rather then Len([adress]) >
> > "33"
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
YAHOO! GROUPS LINKS
- Visit your group "AccessVBACentral" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
