How large can a query be?

[Steff_DK]

I am currently operating queries in my A2K DB that are 35458 characters (~11 full sheets of A4 paper with 12pt).

It takes roughly ½ second for the form to load due to the heavy query that is also calling functions (calc'd fields) from within, but it works fine.

Are there any problems in this?

I think I heard somewhere that queries have a max length of about 2000 characters or so ...

 

[RuralGuy]

The limit in an SQL statement is about 64000 characters. Use Access help and look for Specifications.