Report "looping"

[michaeln_(Guest)]

I^m fairly new to R&R (running version 8) and have a question.____I need to write a report that shows average value for each inventory item. There is an inventory dbf that shows each lot and its purchase price. So, for any particular stock item, there may be 10 records with 10 different purchase prices in the inventory file.____The problem is I need to go through the inventory dbf, find every lot for the particular stock item, then run a calculation to determine the average value then move on to the next stock item and start over again...____How do I step through the stock dbf (which contains a unique record for each stock item) then refer to the inventory dbf to pull all of the records for this particular item??

[kfleming]

Use stock as the master file and create a scan relation to the inventory file. Sort and group by stock number and then create a total that is an average of the purchase price in the inventory file with a reset by stock number. Place this total on a stock group footer and you will have your average price.__Kathleen__R&R Support