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 "Chris" wrote in message news:AE8BD347-AFE9-4112-8B1E-11CDF1DB62C6@microsoft.com... >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
