Hello, I would like to automatise the building (and saving) of 200 queries. The queries are based on one table only. They differ from each other only by the name of the field that is selected. I must make one query on each field, such as "select field1 from MyTable order by field1" , field1 being a sort of parameter.
How could i do that : 1) put the name of each field in an array 2) browse the array from beginning to end so that the program builds the SQL query corresponding to the name of the field (i have a SQL template of the query, one character string is missing : the name of the field) 3) save the query as [name of the field] I have the algorithm, but i am not able to transform it into VBA... Thank you for help, suggestions, or links to help pages on the web Gilbert Clauss [Non-text portions of this message have been removed]
