Re: The string returned by the builder was too long



Thanks Duane! I did as instructed! I named the table lazipcodes. In the
query/criteria I typed: Not in(Select * from lazipcodes) and it came back
with the zipcodes that weren't in LA. Thanks a million!


"Duane Hookom" wrote:

> You should model this in a table. All of your LA zip codes should be
> noted/stored in table. Your zipcodes will change and you shouldn't have to
> modify expressions, you should modify data records.
>
> --
> Duane Hookom
> MS Access MVP
>
>
> "Bolo" <Bolo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:448FB30D-A960-4348-AE16-DC70E57AE1C6@xxxxxxxxxxxxxxxx
> > Thank you for your reply Duane! I was doing a query to eliminate the zip
> > codes that are not in Los Angeles. I must've entered over 300 zip codes.
> > Example:
> > Not In("90001","90002") etc. The query will run up to 130 zip codes.
> > After
> > that, I gave me the above error message. How can I fit all the necessary
> > zip
> > codes? Thanks!
> >
> > "Duane Hookom" wrote:
> >
> >> Can you provide some idea as to the expression you are attempting to
> >> build?
> >>
> >> --
> >> Duane Hookom
> >> MS Access MVP
> >>
> >>
> >> "Bolo" <Bolo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:C67A1E5F-43FA-4521-B08F-A0AC7A9FA5C6@xxxxxxxxxxxxxxxx
> >> > I'm a beginner in Access. I was adding the fields in "criteria" and
> >> > received
> >> > an error message, "The string returned by the builder was too long".
> >> > How
> >> > can
> >> > I increase the field in criteria? Please help!
> >>
> >>
> >>
>
>
>
.