Linking Queries To Compare Information

[Kennedys21]

I have to queries that I am trying to link together. The problem is that
when I link them, it is only showing records tht are alike with the linked
fields. I need the link to compare and show all records so I can see the
similarities and the differences between all the information in both queries.
Is there a way to do this?

 

[Rick Brandt]

I have to queries that I am trying to link together. The problem is
that when I link them, it is only showing records tht are alike with
the linked fields. I need the link to compare and show all records
so I can see the similarities and the differences between all the
information in both queries. Is there a way to do this?

And just what would that look like?

If you don't join on the equality of one or more fields then what record from
Query1 are you going to compare to in Query2? All of them?

If you want to see all records where the linking fields are equal OR where the
value is non-existent in one of them, then you just use an outer join, but it
has to be one of those two.

 

[Kennedys21]

This database is a project for work at a distribution center. It is to
compare what the system says was picked and what people actually picked.

The 2 queries have 2 like fields: [Tote Number] and [Part Number]. The
other field in query A is [Unit Qty] which is system information, and query B
is [Qty Picked] which is what the user actually picked.

I hope this helps explain a little better

 

[Rick Brandt]

This database is a project for work at a distribution center. It is
to compare what the system says was picked and what people actually
picked.

The 2 queries have 2 like fields: [Tote Number] and [Part Number].
The other field in query A is [Unit Qty] which is system information,
and query B is [Qty Picked] which is what the user actually picked.

I hope this helps explain a little better

So your queries should be joined on the fields [Tote Number] and [Part Number]
and then you can include whatever fields from either query that you want to
compare.

 

[Kennedys21]

This database is a project for work at a distribution center. It is
to compare what the system says was picked and what people actually
picked.

The 2 queries have 2 like fields: [Tote Number] and [Part Number].
The other field in query A is [Unit Qty] which is system information,
and query B is [Qty Picked] which is what the user actually picked.

I hope this helps explain a little better

So your queries should be joined on the fields [Tote Number] and [Part Number]
and then you can include whatever fields from either query that you want to
compare.

That is correct. The problem is when I link these fields, I loose data.
Query A has a total of 305 records, and Query B has a total of 298 records.
When I link the queries, I only receive a total of 108 record. The results I
am looking for would be a minimum of 305 in theory.

 

[Rick Brandt]

That is correct. The problem is when I link these fields, I loose
data. Query A has a total of 305 records, and Query B has a total of
298 records. When I link the queries, I only receive a total of 108
record. The results I am looking for would be a minimum of 305 in
theory.

Then you need to change your join to an outer join. If you double-click the
join line the three choices offered are pretty self-explanatory.