The string returned by the builder was too long

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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