Can I save a sql statement generated by a search form?

Joined
Dec 8, 2017
Messages
1
Reaction score
0
I have a form which searches a table on criteria selected on the form. This works well, if I say so myself.
Now I want to run a report based on that same SQL generated by the form. In other words can the sql be saved as a query so I can refer to the query as the record source when I open the report?
 
Joined
Dec 7, 2011
Messages
16
Reaction score
0
Hi Ron,

What you want to do is definitely possible. I do it in some of my applications.

Did you ever get a solution? If not, let me know. I will be glad to assist you.
 

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

Top