joining two queries

D

DD

i have two queries that are joined by PJORD#. one of the queries totals
cases produced by PJPROD and what material is required FFRAWC and STD QTY.
the second query sums what was actually used QryLbs.PJPROD and
QryLbs.SumOfPJTQTY. most times what was supposed to be used and what was
actually used are differnet. what happens is that the FFRAWC and STD QTY
are inserted into each line that the actual used items occur. in this case
doubling the items and qty.

PJORD#
QryCases.QryItem#.MNDESC
QryCases.PJPROD
QryCases.SumOfPJTQTY
ABRLINE
FFRAWC
Std Qty
QryLbs.PJPROD
QryLbs.MNDESC
QryLbs.SumOfPJTQTY

LBL0641970
ttt,GRNBN,WHOLE,12/16OZP
01001088409
844
HY89
01001023000
11647.2
01001023000
GRNBN,WHOLE,2-4SV
13000

LBL0641970
ttt,GRNBN,WHOLE,12/16OZP
01001088409
844
HY89
01001023000
11647.2
01001039000
GRNBN,MXCUT,1",CANNING
2470


what i would like this to look like is

PJORD#
QryCases.QryItem#.MNDESC
QryCases.PJPROD
QryCases.SumOfPJTQTY
ABRLINE
FFRAWC
Std Qty
QryLbs.PJPROD
QryLbs.MNDESC
QryLbs.SumOfPJTQTY

LBL0641970
ACH,GRNBN,WHOLE,12/16OZP
01001088409
844
HY89
01001023000
11647.2
01001023000
GRNBN,WHOLE,2-4SV
13000

LBL0641970
ACH,GRNBN,WHOLE,12/16OZP
01001088409
0
HY89
01001023000
0
01001039000
GRNBN,MXCUT,1",CANNING
2470



the QryCases.SumOfPJTQTY is 0 and STD QTY is 0. is there a way to do this?
i have been trying every which way but can't seem to arrive at the correct
information.



any info would surely be appreciated.



thank you
 
Top