Maximum SQL

[SQLScholar]

Hey all,

Does anyone know if access has a SQL maximum query size (in terms of the code) because either the program i use to query it is stopping me typing or Access is?

It is one huge report, and i dont want to have to see if i can fit it in or not (i hate cramped code)

D

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!

 

[PHV]

One way to shorten sql code is to use aliases like this:
SELECT A.Field1, B.Field2
FROM [name of 1st table] A INNER JOIN [name of 2nd table] B
ON A.PKfield=B.FKfield
instead of:
SELECT [name of 1st table].Field1, [name of 2nd table].Field2
FROM [name of 1st table] INNER JOIN [name of 2nd table]
ON [name of 1st table].PKfield = [name of 2nd table].FKfield

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[OhioSteve]

Many people claim that a definite limit exists. However, I have run union queries that returned more than one million separate records (they ran VERY slowly, but they did run). Personally, I don't think that a predetermined limit exists.

 

[SQLScholar]

thanks again PHV - it might be worth a try

Sorry OhioSteve - it was actually the code that has a limit not the output.

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!