Part joined by PartMtl.
Then in PartMtl added a calculated field Total(req qty);
Part (Typecode=P);
PartMtl ReqDate < 1/3/2015
PartMtl ReqDate > 1/1/2015
But the query never finished. It was over 20 minutes.
Miguel A. Santillan
Compass Manufacturing Systems
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, December 19, 2014 6:13 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RE: E9: Summarize JOb Material Req.
What are your table joins? To go it to summarize by part I think you would have to start with part as the main table and join to jobmtl and summarize jobmtl table. Although I have never tried this…