There are two ways to make queries:

1. simple queries within Access
2. queries with Labview: a simple example is ProductID.vi

Simple queries within Access

• open the database and select queries
• select new  and open it in design view
• always open it in table mode,showiing all tables we have to choose from
• select a table, for example tblwDataTension from the IU database
• close the choose table box; to re-open go to view / show tables
• link two tables to link straw # and spool # from different tables; link them using the product ID #
• left click on product ID # and drag it from one table to the other
• double-click on product ID # to have it appear in the query
• click on the icon called view right under the "file" word: this will run the query
• the results appear in the "view" window; click on design to go back to the design window;
• there are three modes: design, view and SQL
• click on sort and choose some sorting pattern; the first column to be sorted can be dragged to show in the first column
• then add some criteria to refine the search

To link a simple query to another table:

• in design view: right mouse click in the grey section at the top of the query
• show tables
• select tblyModulesList
• select tblyCompletedChecklist
• link product ID by dragging over
• double-click on product ID to include it in query
• double click on procedures
• double-click on step 1 to query on all procedures to see all modules that have been started

To set the ODBC links for Labview (Open DataBase Conductivity)

• from the settings /control panel/ administrative tools / data sources (ODBC)
• under the "User DSN tab: click on "Add".
• select Microsoft Access Driver (*mdb) then click on "Finish".
• data source name: enter a nickname for the database. To get Eddie's comparison programs to run on 16-channel tension tester data, the nicknames should be: CERNDB, IndianaDB, DukeDB, HamptonDB and holesDB. A 6th ODBC connection is needed: nickname: ProductionDB and this one should point to Indiana Interface.mdb.
• click on "Select..." and use the browser to select the desired database (with mdb suffix).
• repeat this for: CERN, IU, Duke, and Hampton databases (and holes DB for Eddie's vi's).