I could really use some help on this one. I am trying to create a recordset based on recordsets from other databases.
Here is an example of my data:
QRY-CastCross:
Date
CastingPN
TotalScrap
TotalShots
QRY-FluorCross:
Date
CastingPN
RejQty
TotalQty
QRY-FinPackCross
Date
MachiningPN
CompanyPN
Total Fin QTY
TBL-Projects
CastingPN
MachiningPN
PartDescription
TBL-ProdScrap
Date
CastingPN
MachiningPN
CompanyPN
TotalShots
TotalQty
TotalFinQty
RejectQty
TBL-Projects is the main table. This is where all of the other tables are driven from. There can be multiple MachiningPN's and CompanyPN's for each CastingPN.
I am needing to tie all of this information together to use in a report. I cannot get the report to read all of the data. I have tried a Union Query but the data remains as individiual pieces of information. I have also tried an append query...same thing...individual. So when, I try to take it into the report, the report does not combine the information based on CastingPN. Rather, it sees the first record and ignores the rest.
Unless anyone can think of another way for me to achieve my goal, I need to match records from QRY-CastCross to TBL-ProdScrap based on CastingPN, QRY-FinPackCross to TBL-ProdScrap based on MachiningPN, etc. Basically if a casting pn is 43783 I need it to find 43783 and apply all of the records in the query to the designated fields in TBL-ProdScrap and for it to look first and see which 43783 fields in that aren't null.
I hope you can understand what I am trying to accomplish. Any help would be greatly appreciated.
Here is an example of my data:
QRY-CastCross:
Date
CastingPN
TotalScrap
TotalShots
QRY-FluorCross:
Date
CastingPN
RejQty
TotalQty
QRY-FinPackCross
Date
MachiningPN
CompanyPN
Total Fin QTY
TBL-Projects
CastingPN
MachiningPN
PartDescription
TBL-ProdScrap
Date
CastingPN
MachiningPN
CompanyPN
TotalShots
TotalQty
TotalFinQty
RejectQty
TBL-Projects is the main table. This is where all of the other tables are driven from. There can be multiple MachiningPN's and CompanyPN's for each CastingPN.
I am needing to tie all of this information together to use in a report. I cannot get the report to read all of the data. I have tried a Union Query but the data remains as individiual pieces of information. I have also tried an append query...same thing...individual. So when, I try to take it into the report, the report does not combine the information based on CastingPN. Rather, it sees the first record and ignores the rest.
Unless anyone can think of another way for me to achieve my goal, I need to match records from QRY-CastCross to TBL-ProdScrap based on CastingPN, QRY-FinPackCross to TBL-ProdScrap based on MachiningPN, etc. Basically if a casting pn is 43783 I need it to find 43783 and apply all of the records in the query to the designated fields in TBL-ProdScrap and for it to look first and see which 43783 fields in that aren't null.
I hope you can understand what I am trying to accomplish. Any help would be greatly appreciated.
