[CLOSED] SUM, showing pieces from multiple records for each result
I'm not sure if this is possible. I need to spin thru the following table summing NBR by TITLE. The table shows categories, some are "details" (type A) and some are "combinations" (type B). Details make up combinations, and for each detail category line, the "combinations" column contains which combinations they go into.
The report I'm trying to make would show the following:
For each "A" type, I show NBR and TITLE. For each "B" type, I show NBR, TITLE, and the respective DETAILS that it consists of. Problem is, the details are scattered throughout the entire table.
Representation of data:
IND NBR TITLE COMBINATIONS --------------------------------- A 101 title1 B 103 B 105 A 102 title2 B 103 B 103 title3 A 104 title4 B 103 B 105 title5 A 106 title6 B 105 A 107 title7 B 103 B 105
Would I need to run thru once, table the NBR & TITLE, create a hold and then run through again looking for detail matches, or can this be done in one pass?? Thank you to any ideas.This message has been edited. Last edited by: CD960,
Cobol, Foc 7.6.5, VBA all Outputs
February 16, 2011, 03:00 PM
Doug
What's your MFD look like? It looks like your data is rather random, is it really?
Post a copy of your MFD for us to see.
February 16, 2011, 03:19 PM
CD960
Yeah, it does look a bit messy, but the data is actually that random. What holds it together is a sequence number that I didn't mention, which will not be displayed in the output. This is the MFD: