Need Code to Perform Calculation

P

Paul

I have a form/subform arrangement where Landfill Ticket Cost is entered and
needs to be appropriated accross the various Job#'s associated with that
particular Ticket, according to the following formula - <CalculatedCost> per
<Job#> = <Cost> *{((<#Bags>/10)+<#Barrels>+<#Other>)for each job
/((<#Bags>/10)+<#Barrels>+<#Other>)}for the Active <Ticket#>. Basically, we
are saying that the cost of 10 bags is equal to the cost of 1 Barrel or 1
Other; And that the cost proportioned according to the percentage of the
<Cost> that each <Job#> represents.

The information is enetered starting from the top of the form and then it
jumps into the subform where the <Job#>, <#Bags>, <#Barrels>, <#Other> are
entered per line; When the cursor gets to <CalculatedCost> we tab to the next
line and enter more <Job#> data that was part of the dump <Ticket#>

See Example Below:

FORM
<Landfil> Hamburg
<Date> 12/1/04
<Cost> $1000.00
<Ticket#> 123-01a

SUBFORM
<Job#> <#Bags> <#Barrels> <#Other> <CalculatedCost>
2004001 2 5 1
?1
2004002 7 0 0
?2
2004007 0 12 1
?3
2004010 0 0 110
?4


Ideally, I would like to enter an Event where we can click a "Calculate"
button on the form, but I need to know how to write the formula.
Many Thanks for any help.
Paul
 
Top