What is the max query size?

  • Thread starter Thread starter ZBC
  • Start date Start date
Z

ZBC

Is there a max to the size of the SQL size or the number of Columns in
the design view?
My query started giving me errors (not recognizing some fields) when I
added 3 more calculated columns in the design mode.
Bob
 
An Access query statement can be up to 64000 characters, with up to 255
fields.

An individual cell in query design view is limited to 1024 characters.

You may find that the combined characters in all the fields in any row is
limited to around 2000 characters.
 
Back
Top