creating customized queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

use field list from form to specify query fields 2
One query for report and Excel 3
Query Question 1
Filtering a Query then Exporting to Excel using VB 1
Multiple Parameter Crosstab query filter by form 1
Query Criteria Not Working 2
SQL query help 8
Converting a query to a WHERE condition 12

Back
Top