Quiz/QTP help

[MaxButen]

It's easy - after you've done it 20 times!

:QUIZ
ACC subfileA
SET SUBFILE NAME subfileC KEEP
REPORT SUMMARY STORE-NO ITEM-NO QTY-SOLD
limits, GO, etc

ACC subfileB
DEFINE QTY-SOLD = 0
SET SUBFILE NAME subfileC APPEND
REPORT SUMMARY STORE-NO ITEM-NO QTY-SOLD
limits, GO, etc

ACC subfileC
SORT ON STORE-NO ON ITEM-NO
SET SUBFILE NAME subfileD KEEP AT ITEM-NO
REPORT SUMMARY STORE-NO ITEM-NO QTY-SOLD MAX (or SUBTOTAL)
limits, GO, etc                          ***

Max



Tracy White wrote:
> 
> We have been flummoxed at my office by what sounds like it
> ought to be easy:
> 
> >From a subfileA containing sales data by store and item:
> STORE-NO ITEM-NO QTY-SOLD
> 1                10001    5
> 2                10003    7
> 4                10004    6
> 
> and a subfileB containing a list of all stores:
> 1
> 2
> 3
> 4
> 
> we wish to create a subfile of all item and store
> combinations, with QTY-SOLD = 0 for the 'dummy' records:
> STORE-NO ITEM-NO QTY-SOLD
> 1                10001    5
> 2                10001    0
> 3                10001    0
> 4                10001    0
> 1                10003    0
> 2                10003    7
> 3                10003    0
> 4                10003    0
> 1                10004    0
> 2                10004    0
> 3                10004    0
> 4                10004    6
> 
> Does anyone have any advice on how to reach this final
> state?
> 
> PH7.29x on HP3000.
> 
> Thanks,
> Tracy White
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.

-- 
Max Buten - Powerhouse Programming Consultant - maxbuten@home.com  (610)
664 2301
http://members.home.net/maxbuten/
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.