Getting the total yields

D

dbaggett

I work with a computer that gathers data from 3 different touch screens. The
data keyed in has similar data, such as:
Date; Color; Coating; PartDesc; so on..

The difference is :
The 1st screen the number of parts loaded on the line is keyed in.
The 2nd screen the number good parts are keyed in.
The 3rd screen the number of bad (by reject type) are keyed in.

I use a crosstab query to get the number of each type reject by Part number.
I need to get the total of each part loaded, which is simple, with the
crosstab query. My problem is the part numbers that have "no" rejects (in
other words they ran 100% good) will not show up. Is there anyway to show all
the parts run, even if they show no rejects?

Thanks,
 
J

John W. Vinson

Is there anyway to show all
the parts run, even if they show no rejects?
Click to expand...

Yes. Use an "Outer Join" to join the parts table to your rejects table. Select
the join line and choose the option "Show all records in Parts and matching
records in..."


John W. Vinson [MVP]
 
Top