I have a feeling that the solution I'm looking for is super simple. I am, however, a total noob to Access and queries, and have only been taught how to do a couple simple things in Access for my employer.
I'm looking to perform a query with data from two tables. I can run the query, and all the data combined from both tables pops up. That's all well and good, but now I want the query to filter the data based on an identifier that I've incorporated into a 3rd table.
Details: I have water sample data that I need to organize. Table 1 has the lab results based on the sample ID, and the Table 2 links the Sample ID to a location name and sample date. I have a 3rd table that is a list of all the compounds that we test for. In this third table, I've added a column that identifies certain compounds as metals. I can't manually ID all of the compounds in Table 1 because there are thousands of records, so I want the query to filter those records and only give me the data of compounds that I have listed as "metals" in Table 3. Make sense? Again, I'm sure it's a quick solution, but I'm pretty sure that's something Access can do and I just don't know how yet...
Thanks in advance!
Bookmarks