Help....please code problem in access

[rbarrett]

Hi, I have a small problem. I am trying to create a gain/loss report for my office and I need to create a loop code that will pull the most recent inventory up to a certin volume. We receive several shipments per month. The report needs to pull the most recent shipments untill it can't pull any other whole shipments, and then it needs to pull a partial shipment so;
Our off site inventory reprot says 150,050 widgets. I need the report to pull
Widget 1 50,000
Widget 2 50,000
Widget 3 50,000
Widget 4(partial) 50


This is what I have to work with:
GandL form: you enter the product code, off site inventory volume, and market cost.

GandL query: The query pulls product code, volume, and inventory value sorted in ascending order.

Report: the report has(among other things) Product code, volume to be applied, inventory value, market value, and totals.

How do I create a loop that will bring back only the volumes that will total the inventory volume that is entered on the form?
and Which one would I put the code in (thinking report)? Thank you for all your help in advance I have been trying to get a clear answer on this for a while and none of my books or classes goes into this with too much detail. Thanks again
RMB