Queries from two queries

[Guest]

I need a query to show results of 2 queries.
Query1 fields: PN, SQty, SCost
Query2 fields: PN, AQty, Acost
Both queries are joined by PN. I need the results of both queries to show
as follows:
PN, SQty, SCost, AQty, ACost.

For example:
Query1 data:
PN SQty SCost
100 5 1.5
200 3 1.2

Query2 data:
PN SQty SCost
100 9 2.1
300 7 2.5

The resulting query should be:
PN SQty SCost SQty SCost
100 5 1.5 9 2.1
200 3 1.2
300 7 2.5

I tried Left Join and Inner Join on PN but neith works. Has anyone worked
on this successfuly before? Thank you in advance.

 

[Crystal]

Hi Samantha,

Include your Parts table

Join each query to the Parts table and show all records from
the parts table with your Joins

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access