The string returned by the builder was too long

B

Bolo

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!
 
B

Bolo

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!
 
D

Duane Hookom

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.
 
B

Bolo

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!
 
Top