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

Discussion in 'Access' started by Ron Hovland, Dec 8, 2017.

  1. Ron Hovland

    Ron Hovland

    Joined:
    Dec 8, 2017
    Messages:
    1
    Likes Received:
    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?
     
    Ron Hovland, Dec 8, 2017
    #1
    1. Advertisements

  2. Ron Hovland

    HiTechCoach

    Joined:
    Dec 7, 2011
    Messages:
    16
    Likes Received:
    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.
     
    HiTechCoach, Nov 4, 2018
    #2
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.