calculation of day with reference of daterange

[joshynaresh]

Dear Sir, I have transaction statement. i want to select transaction with given date range and calculate days length between two transaction. but for last transaction days length it should be calculate last date range - last transaction days. i have uploaded sample days calculation formate sheet.Thanks in advance.

[June7]

Your attachment did not load.

Not really understanding your requirements but may be this will help http://allenbrowne.com/subquery-01.html#AnotherRecord

[enquiries]

If you're trying to have a calculated field in a form that calculates the difference between two dates you can in the control source property of the field add this method:
=DateDiff("d",[DateOne],[DateTwo])+Int(Format([DateTwo], "mmdd")<Format([DateOne],"mmdd"))
Hope that helps.

[joshynaresh]

sorry buddy, my attachement has been missing. now i have attached.

[June7]

I still don't understand your requirements. And the data example confuses me even more. Why is the later date shown first in the range? These dates are not displayed in Access standard. Review http://allenbrowne.com/ser-36.html

[joshynaresh]

Let me explain in details:I want to calculate interest on daily balance. For that, days are required. Days denoted how many days certain balance has outstanding. in above image, date column is reference that in which date transaction has done. Day’s column denotes days lag between two transactions. Final column is just working notes how days lag has been calculated (to understand).But in final row, days lag has calculated by subtracting last date range and 2nd last transaction date.Thank You in advance.

[June7]

You want to calculate compounded interest? Sorry, that is beyond me. Did you search web? Bing: Access database calculate compound interest
http://ms-access.questionfor.info/q_...ase_41416.html

Did you review the link about date structure?

[trevor40]

Are you using Excel or Access for this ? In post #6 you talk of rows and columns!

[joshynaresh]

dear june7,
I'm not trying to calculate compound interest. i want to calculate interest on daily balance method for that loan outstanding days required. now i just want to calculate days lag between two transaction.

Dear trevor40,
I'm talking about Access. i have explained my example on post #6. i have used row and column word for understanding my example simply.
Thank You

[June7]

Still don't understand the interest requirement.

Perhaps if you provide an example of the actual raw data and an example of the desired output.