Explore BrainMass

Explore BrainMass

    Access Database Search Form with Queries

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Create a query in Access. You have several users and would want to create a query where you can pull information from 3 tables (Lab Audit, Gas Cylinder Pressure Reading, and GC ID Mix analysis) for one particular user. The query should ask for user name (or initials) and a date range as input.
    Database is attached.

    © BrainMass Inc. brainmass.com December 24, 2021, 11:25 pm ad1c9bdddf
    https://brainmass.com/computer-science/databases/access-database-search-form-queries-568046

    Attachments

    SOLUTION This solution is FREE courtesy of BrainMass!

    I have create a form called "Search Form" where you have Initials as criteria and date range. You then press "Search" button and the 3 grids from (Lab Audit, Gas Cylinder Pressure Reading, and GC ID Mix analysis) will be populated according to criteria. I did enter a couple of values into table GC ID Mix analysis, since it had no records. They way it works is as follows: we create search form with criteria controls. We then create a query for each of the tables and add criteria in these queries to match search control values. After that I created 3 sub forms for each of the queries and placed the sub forms on the main search form.
    You can test placing Initials="KK" and date range from 12/01/2013 to 12/31/2013.

    Please see attached.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    © BrainMass Inc. brainmass.com December 24, 2021, 11:25 pm ad1c9bdddf>
    https://brainmass.com/computer-science/databases/access-database-search-form-queries-568046

    Attachments

    ADVERTISEMENT