queries (1 Viewer)

[Liz Morrin]

I AM TRYING TO CALCULATE A PERCENTAGE . HOW DO I GET IT TO TOTAL FOR A
CERTAIN AMOUNT OF TIME WHICH VARIES FOR EACH FILE. FOR EXAMPLE,
([AMOUNT OWED])*23.90... THE PROBLEM IS HOW TO I GET THIS EXPRESSION TO WORK
(AMOUNT OWED TIMES 23.90 % DIVIDED BY 12 AND THEN TIMES THIS BY THE NUMBER
OF ACTUAL MONTHS IN DEFAULT.
ALSO HOW DO I TELL THE PROGRAM THAT I WANT THE INTEREST TO ACCRUE ON A
DAILY BASIS. ANY HELP WOULD BE GREATLY APPRECIATED.

 

[jatfill]

Hi
I think the expression you're trying to create would need to look like the following (almost exactly as you worded it):

= (([AMOUNT OWED]*.239)/12)*[FIELDNAME])

replace 'fieldname' with the name of the field that contains the no. of months in default as you suggested...

If the number of months in default depends on a start date or other single date control as opposed to an actual number of months, change it to the following:


= (([AMOUNT OWED]*0.239)/12)*(DateDiff("m",[DATEFIELDNAME],Date()))

Doing this second method will cause the query to update the total every time it is run, since the date is compared against the current day, so the amount calculated will "accrue" every time the query is run.

I'm not sure if this is exactly what you need, but you can try this as a start & post a response if you need more specific information.

Good Luck...