Charlotte Foust
charlotte.foust at gmail.com
Sat May 26 10:18:14 CDT 2012
I actually did something analogous to this years ago in Access (and no, I have no idea what happened to the code). I built a class to handle the record processing and then passed a limited recordset into the class. It was clunky, but so was the requirement (can you say government? Sure you can!) and it did the job. Don't recall the details, unfortunately (It was probably 15 years ago). Charlotte Foust On Fri, May 25, 2012 at 11:31 PM, Paul Hartland < paul.hartland at googlemail.com> wrote: > Believe me there is no logic to this, my company all over, basically we > have the purchase order table (there is a main one with PO no as primary > key) which has the details of the PO, and then we have a credit card table > and we match the credit card amounts to the po amounts, so according to our > company (that knows best (yeah right)) at the end of the day as long as the > purchase order gets matched to one or more credit card lines then thats ok > (LMAO) > > Paul (who wants to work for a decent company one day) > > On 25 May 2012 15:44, Charlotte Foust <charlotte.foust at gmail.com> wrote: > > > I see what you're trying to do, but why are you trying to do it? Does > > "Allocated" mean paid or to be paid? Or are you trying to figure out > what > > should be paid and what left out? What logic would be applied? Would > the > > largest Amount receive it's allocation first? Would they go in date > > order? It feels like there is a piece missing in this logic. > > > > Charlotte Foust > > > > On Fri, May 25, 2012 at 5:35 AM, Paul Hartland < > > paul.hartland at googlemail.com > > > wrote: > > > > > To all, > > > > > > I will try and explain the problem as best as I possibly can, for this > > > purpose lets say I have two tables, PODetail which holds detail records > > for > > > a purchase order, and a table containing a value which we have > currently > > > allocated to a single purchase order number POAllocation > > > > > > PODetail > > > PoNumber Amount Allocated RowID > > > 123456 50.00 0 1 > > > 123456 20.00 0 2 > > > 123456 76.00 0 3 > > > > > > POAllocation > > > PONumber Allocated > > > 123456 141.00 > > > > > > What I need to do is update the Allocated field in PODetail with a > value, > > > the way I want to do this is get the PO number and allocated amount > from > > > POAllocation and then loop through the PODetail records updating the > > > Allocated field, so I would come to record (rowid) 1 if the allocated > > > amount is less than 50.00 then update the allocated field with that > > value, > > > if the allocated amount is great than 50.00 then update the allocated > > field > > > to 50.00, take 50.00 away from 141.00 to get 91.00 then report the > > process > > > for record (rowid) 2. > > > > > > I am thinking/in middle of writing a cursor inside a cursor, anyone > else > > > any better ideas on how to do this. > > > > > > Thanks in advance for any help. > > > > > > > > > -- > > > Paul Hartland > > > paul.hartland at googlemail.com > > > -- > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > > > Website: http://www.databaseadvisors.com > > > > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > > > Website: http://www.databaseadvisors.com > > > > > > > > -- > Paul Hartland > paul.hartland at googlemail.com > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > >