>I think my SQL select statement is crashing because it has more than 255 characters in it - I am mainly using macro substitution and I can't reduce the statement any further - is there anything I could try to get it to work?
Split the query in 2 or more queries.
The second starting with the results of the first one.
:-)
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca 
