I have a data file containing transaction numbers and quantities for items received. I need to select transactions received in the last 45 days and then find all transactions for that same item so I can find the total quantity received for that item. From there I can find the 45 day average. Finding the average is the easy part! Finding the proper records is where I'm in the dark.
I know I need a loop within a loop but I'll be darned if I can figure it out. I tried returning a list of transaction meeting the criteria and then selecting and returning a list of transactions based on the key from the first list but I don't know how I can total the quantity from there. Maybe I'm not even on the right track. Any thoughts on how I might achieve this. Thanks in advance, WW --~--~---------~--~----~------------~-------~--~----~ Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---
