look easier than it is Report problem

[RBE]

Ok I have a difficult one for you. I have a form that you enter the check amount [frmAP](field=[check_amount]) I have a table with customers orders(orders_table).I have a query [qryAP] pulls the order number and order $amount, and I have a report that is suposed to bring back the orders the check is to be applied to. For some reason this seems to be more difficult than it looks. I have tryed other boards to no avail. Here is the problem: I need to loop through all the invoices that the query brings up, sum them together, and when the invoice running sum =< the check amount I need it to bring back these orders, then I need it to apply the remainder of the check to the next order. So I will have a partial order paid. I have no problem creating new tables, sub querys or adding fields. I just need to get this solved. I am sorry for the long intro but I figure the more detail the better chance of getting a functional answer. Thanks for all your help in advance RBE

 

[MichaelRed]

Well, I think you need to state the &quot;problem&quot; in a formal manner. Include some (small) sample of the various components. This should illustrate some of the issues.

[tab]The &quot; ... running sum =< the check amount ... &quot; will generally be true

[tab]You need to know what ammount (if any) has been applied to the order. You WILL need to know wha check that amount came from.

The above are just from the briefest persual of your request. If you follow the suggestion of a FORMAL problem statement and a sample, I'm sure additional issues/items will be obvious.

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over