Thanks Jim,
It might save me this time. Anybody with a long term solution?
José
>José,
>
>I did *not* do detailed calculation, but I think you could save enough lenght to fit if you revised the original code to use real short 'aliases' for the file names. I am PRESUMING that these work with INNER/OUTER JOIN code.
>
>What I mean is something along the lines of. . .
>
> FROM (((Autosoft!Coleur A INNER JOIN Autosoft!Marque B ON A.cMarqueID = B.cID. . .
>
>Doing this for all files named, and using the A B C etc as appropriate throughout the code will shorten it a lot. Maybe enough.
>
>Good Luck,
>Jim N
>