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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Urgent query needed 2
ViewSonic VG2757V-2K Display with Inbuilt Webcam and Multifunctional Docking Station Unboxing 4
The query cannot be completed. 1
ViewSonic VX2758A-2K-PRO-3 Gaming Monitor with 2K and 240Hz Unboxing 2
Query Help: Max Value in A Row 1
Aggregate Query Question 1
CALCULATIONS 4
A query for 12 month rolling values 0

Back
Top