Trouble with 2 table Query

[dmanonice]

Hello Everyone,

I am trying to create a query that pulls data from 2 tables and I have had no luck with trial and error (I am teaching myself Access as I go) to do what i want.

In the first table I have the ID field, the date and the unit and a result, and the second table i have the ID field, the date, the unit, and various operational data. Due to data source formatting the ID fields are not the same in each table. The units are the same in both tables, just in different order and repeat every day.



What i would like to do, is select a unit and result for table 1, the result is a Yes or No, and then from the second table pull the operational data that matches the unit number and date.

So for example I would select the Unit "B" and the result "N" and that query returns 5 results. I want to then bring over the operational data from the second table using the unit and date from the 5 results of the first query.

I have the first query created and functioning properly, I am lost at how to get the second part done.

I hope this all logical and can be done, doing it by hand right now and thinking there must be a better way.

Thanks

[Gicu]

Without a sample db and some desired input/output examples is hard to get you an answer, but have you tried to join the two tables by both unit and date fields (two join lines going from one table to the other)?

Cheers,

[dmanonice]

I have attached a sample db with the data that I am trying to get to work. I have the first part of the query set up but have cleared everything else. I have tried the double join but I may be doing something wrong, I am a complete newbie at Access and am learning as I go. not too concerned about output, I am can fiddle with the output and know how to manipulate reports and the query formatting. I just want the data all in the same place at the moment.

So the query right now pulls the data as i want it to, now i want that query data result to pull all fields from table 2 into the same query result, without duplicating the date and unit.

[Gicu]

Is this what you're after?
Cheers,

[dmanonice]

Yes that is exactly what i am looking for. The set up looks similar to what I tried before, I must have done something wonky in my first attempts.

Thank you very much for the help!