Good point, John. I always forget these functions, but they're very useful for handling large amounts of text. Just be sure you delete the temporary file when you're done with it.

Barbara

>Hi Mauricio
>
>What Barbara mentioned about the 254 characters is true. If your queries are long you are going to run into trouble unless you string together several macro's.
>
>If your queries are going to be this long, another solution for you to consider is to use the strtofile() and filetostr() functions. Here you can just keep adding the properly formatted text that makes up the query to one file. When you are ready to execute use the filetostr() function, and then delete the file.
>
>
>
>
>>I want to let the users choose from a lot of options in a Form, then, based on that options, my aplication build an SQL statement and store it in a String.
>>
>>Something like this:
>>
>>sStatement = "SELECT * FROM " + Combo1.Value + " ORDER BY " + Combo2.Value
>>
>>
>>Actually I create more complicated Querys, but that´s the idea.
>>
>>I do not want to create a fixed Query for all the 130 diferent combinatios that the user can choose from, so I need to do something like that.
>>
>>As you can see, not only the variables values are going to change, also the table names and field names will.
>>
>>I`m using a local Database
>>
>>
>>Thanks in advance