Table Union Question

[Caulerpa]

Hello Everyone!

Okay I have a SIMPLER way of putting my other question AND I've added a visual to help! I have Table A and Table B. Both tables have three columns: SAMPLE ID (will match in both tables), RESULTS, and SAMPLE_METHOD. There is sample method X and Y.



Right now when I make a union between two tables it spits out three columns and sample X and Y are both in the same column. What I'm looking for is a way to have a union spit out a table with FIVE columns: STAMPLE ID, SAMPLE METHOD X, RESULTS X, SAMPLE METHOD Y, RESULTS Y. If this doesn't make sense I tried to make a visual below.



Anyway, if you could offer any help I would really appreciate it.

[pbaldy]

You don't want a union query, just a standard join. Add both tables to a new query. If one doesn't appear automatically, click/drag to create a join between the sample ID fields in both tables. Double click on the fields from each table desired in the result. see if that gets you the result you're after.

[Caulerpa]

Thank you for your response! Unfortunately, I did exactly what you told me to do and NOTHING came back from the query :[

Thank you though.

[pbaldy]

What is the SQL of the query? Can you post the db here?

[Caulerpa]

ARGH! I just realized the Sample ID's are NOT the same in both tables! -_- sorry for wasting your time.

I just realized what I really need to do is first pull data from both tables based on their GROUP ID and then only grab data from both tables if they have the same sample intervals. I can't really post anything directly related to what I'm working on because it's company property - sorry to make it more difficult.

A revised image of what I need is below.



Again, I have never used Access before and was told I needed to do this so if you're still willing to help me after I made a mistake I would be most appreciative.

[pbaldy]

Well, I'd give the same answer with a twist. We join tables in a query using the field or fields which relate them. From the sound of it, perhaps that's all 3 fields?