Explore BrainMass

Explore BrainMass

    Access Database Search Form with Queries

    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 October 10, 2019, 7:05 am ad1c9bdddf


    Solution Preview

    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 ...

    Solution Summary

    A search form that has several criteria calls 3 different queries and populates results in sub-forms that are placed on the search form.