I have a form on which the user can choose an existing table or query. The
user then identifies filter criteria using a provided field list, operators
(<,>, =, etc.) and values to, in essence, specify their own filter by form.
Ultimately, I want to export the results to an Excel spreadsheet. My problem
is that in my VB, I can build a Select statement using the fields on my form
and can output a query to Excel, but I can't seem to turn my Select statement
into the query that I then reference in my OutputTo statement. Any help would
be much appreciated.
Thanks.