X
XeniaEagle
I have 2 reports based on query's one query uses start date and end date,
and the other has no date required.
My report for start and end date works fine.
My other report is for all records,
My problem is at the end of the year 10/31/04 or any other date. the
calculation changes, and starts over. I want my report to calculate the
totals for 1 year and keep calculation for the next year.
Here is what I am using
=IIf(Sum([NetProfit])<=75000,0.25*Sum([NetProfit]),18750+0.5*(Sum([NetProfit])-75000))
This works great as long as I use the start and end date for each year.
But the one which uses all records only calculates the 75000 one time,
So if I have records from 11/01/02 to 11/01/04 it only decucts the 7500
one time and it should deduct it 2 times. Every year at 11/01 it needs to
add another 75000
I know this is long, but I hope I explained it enough.
Any help is appreciated
Thanks
Roger
and the other has no date required.
My report for start and end date works fine.
My other report is for all records,
My problem is at the end of the year 10/31/04 or any other date. the
calculation changes, and starts over. I want my report to calculate the
totals for 1 year and keep calculation for the next year.
Here is what I am using
=IIf(Sum([NetProfit])<=75000,0.25*Sum([NetProfit]),18750+0.5*(Sum([NetProfit])-75000))
This works great as long as I use the start and end date for each year.
But the one which uses all records only calculates the 75000 one time,
So if I have records from 11/01/02 to 11/01/04 it only decucts the 7500
one time and it should deduct it 2 times. Every year at 11/01 it needs to
add another 75000
I know this is long, but I hope I explained it enough.
Any help is appreciated
Thanks
Roger