Handling a Running Total

[AnnieDragon]

I'm making this harder than this is...

In nutshell, here's my problem that I know I'm making too much of...

I'm converting old payment ledgers into electronic format.

Payment is kept as a running total

sometimes payment=fee
other times payment=altfee

fee=volume*rate
altfee is a variable rate (pay-off amounts, old math errors, misc payments...)

Volume & Rate need to be calculated at all times

What I tried to do was put vol and rate in one table & total that in a query - but with the rest, I don't know. It was threatening to get big & ugly.

Any suggestions on how to handle this??

 

[MHM]

Hay Annie,

looks like a query question: Imagine you found the right kind of function for your query taking "other times" into consideration - would that solve the problem?

The function may be found in the section "DomainFunctions" (in the expression editor).

So one of the field contents of the query could be:
My calculated content: IIf(DLookup("OneFieldName", "NameOfTableOrQueryWhereDataCanBeFound", "ConditionToFindMatchingRecordInTable_orNone")="sometimes", Volume*rate, Volume * getMyAppropriateRate(MyParameter0, MyParameter1, ...))

The DLookup function can return a value from another table, the IIf(<expression>, <truePart>, <falsePart>) returns a conditional value.


Hope this helps.

Mic

 

[Laney]

Re: I'm making this harder than this is...

In nutshell, here's my problem that I know I'm making too much of...

I'm converting old payment ledgers into electronic format.

Payment is kept as a running total

sometimes payment=fee
other times payment=altfee

fee=volume*rate
altfee is a variable rate (pay-off amounts, old math errors, misc payments...)

Volume & Rate need to be calculated at all times

What I tried to do was put vol and rate in one table & total that in a query - but with the rest, I don't know. It was threatening to get big & ugly.

Any suggestions on how to handle this??

Have you tried making a form or going into an existing form and putting a text box that just has the simple formula to add those two columns together? I would just make a simple form or subform to add into another form you're working with .... a text box to =sum[Volume] then a text box to =sum[Rate]

Once you have those two boxes set up you can double click on them and see what the properties are. They'll tell you they're named textbox32 and textbox36 or something like that. Then you'll need a separate text box that uses a formula to add the two or subtract the two whatever you want to do. All you would type in that one is: =[Volume]+[Rate] and hit enter.

Then just change the titles showing on your text boxes to Volume, Rate, Totals and that's it.

If that's for sure what you're asking ... hehehe hope it helps.