Storing Query Into Table - Using the Stored query

[Craig Ferrier]

I have been trying to find some information about storing query sql strings
in a table and calling upon that string to run query's dependant on user
selections in a form.

I have a split database and I want the users of the front end to create
queries that everyone can use.

Can anyone point me in the right direction on where to start.

Thanks
Craig

 

[Duane Hookom]

There is a complete query by form applet at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
allows users to select field, enter criteria, sort, group, and run. The
results are displayed in a datasheet subform with buttons to send the results
to print, csv, Excel, Word Merge, Word Table, html, graph, form letter, etc.