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.
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.© BrainMass Inc. brainmass.com December 24, 2021, 11:25 pm ad1c9bdddf>