Different Values for Different Date Ranges

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I am tracking expenses on a line of credit that I have and I pay $50 for the
first 30 days of an advance an additional $20 for every 30 days after that.
In a form I already have a section that tracks the number of days I have an
advance outstanding. I need to enter a control source in new section to read
$50 between 0 and 30 days an advance is outstanding and $70 between 31 and 60
days and so on.

I am not a beginner with Access by I am not what you would call advanced.
If anyone can help I would appreciate it.

Chris
 
Chris,

=IIF(DayCount=0,0,IIF(DayCount<31,50,50+(Int((DayCount-30)/30)*20))

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Back
Top