[AccessD] search 4 characters

Hi Stuart, Roz andPaul,

when i see this question again, i understand why i went home, being sick and
going to bed.
Otherwise i could not have forgotten Len. Or my brain is overloaded lately,
because of to much reading.

Thanks

Pedro



----- Original Message -----
From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, May 11, 2005 11:42 AM
Subject: Re: [AccessD] search 4 characters


> On 11 May 2005 at 10:47, pedro at plex.nl wrote:
>
> > Hello Group,
> >
> > what can i use in a query to search for strings that have only 4
characters.
> >
> > Like "&&&&"
> >
>
> Create a field =Len(myField)  with a criteria of 4
>
> --
> Stuart
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>