My Assistant
Custom Search

Series Of Dates, Label As 1,2,3... From A Start Date, Access 2016 
Dec 26 2017, 02:33 PM Post#1  
Posts: 85 Joined: 28August 15  Hello Wasn't quite sure how to describe this in the topic title. Don't think I've done it justice! In a table I have all the dates between 1 Jan 2017 and 31 Dec 2030. I would like to be able to group/rank/label the dates with a number based on a start date. (This is for helping to calculate bank interest, by the way, if that's of any use). So, one interest rate might start on 9 Jan 2017, and be paid monthly, but calculated daily. So I'd like to label all the dates from 9 Jan to 8 Feb with 1, then 9 Feb to 8 Mar with 2, then 9 Mar to 8 Apr with 3, etc. etc. Like so:
I feel like this COULD be done using SQL in a query. With a function or a subquery or some combo. Can't quite wrap my head around it yet though. (or perhaps someone who knows more about bank interest can point me to already existing functions to help with this. I feel like they must exist!) Thanks, as always, for any tips/advice Chris  
Dec 26 2017, 03:56 PM Post#2  
UtterAccess VIP Posts: 12,431 Joined: 6June 05 From: Dunbar,Scotland  Hi Chris The mathematical formula for calculating EMIs is: EMI = [P x R x (1+R)^N]/[(1+R)^N1], where P stands for the loan amount or principal, R is the interest rate per month [if the interest rate per annum is 11%, then the rate of interest will be 11/(12 x 100)], and N is the number of monthly instalments.  Hope this helps? Mike Get happiness out of your work or you may never know what happiness is. 
Custom Search

Search Top LoFi  21st January 2018  03:43 PM 