G
Guest
I have a query that is based on a 2 tables. The first is the primary, the
second is based of off the first with linked field.
I am trying to get the query to show all records with sum of product (first
table) and sum of rejects (second table) even if there are no rejects.
Currently I get:
Model Plant SumOfTotal Produced SumOfRejects
BC-TYP-12 41 26 2
BC-TYP-24 41 122 7
BC-TYP-30 41 140 2
BC-TYP-6 41 24 8
When I should get
Model Plant SumOfTotal Produced
Model Plant SumOfTotal Produced
BC-TYP-12 41 26 2
BC-TYP-16 41 95 0
BC-TYP-20 41 300 0
BC-TYP-24 41 122 7
BC-TYP-30 41 140 2
BC-TYP-36 41 2 0
BC-TYP-6 41 24 8
BC-TYP-9 41 123 0
How can I force the ones that do not have a linked record to show the value
and set it as zero? What do I need to type or enter in the query
requirements or calculation fields?
second is based of off the first with linked field.
I am trying to get the query to show all records with sum of product (first
table) and sum of rejects (second table) even if there are no rejects.
Currently I get:
Model Plant SumOfTotal Produced SumOfRejects
BC-TYP-12 41 26 2
BC-TYP-24 41 122 7
BC-TYP-30 41 140 2
BC-TYP-6 41 24 8
When I should get
Model Plant SumOfTotal Produced
Model Plant SumOfTotal Produced
BC-TYP-12 41 26 2
BC-TYP-16 41 95 0
BC-TYP-20 41 300 0
BC-TYP-24 41 122 7
BC-TYP-30 41 140 2
BC-TYP-36 41 2 0
BC-TYP-6 41 24 8
BC-TYP-9 41 123 0
How can I force the ones that do not have a linked record to show the value
and set it as zero? What do I need to type or enter in the query
requirements or calculation fields?