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.
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 ...
A search form that has several criteria calls 3 different queries and populates results in sub-forms that are placed on the search form.