create specific months between start date and end date

  • Thread starter Thread starter momo_brad
  • Start date Start date
M

momo_brad

I have start dates and end dates for licences over a period which they are
expected to generate an average monthly revenue (calclulated from other
tables). I used a datediff function to get the number of "active" months per
licence but need to somehow create a record for each licence for each month
it is active so I can apply the revenue value monthly and be able to display
monthly totals and yearly totals in a report. any suggestions?

thanks
 
On Thu, 27 Nov 2008 11:54:01 -0800, momo_brad

The classic solution is to have a table with all months in it, and
outer-join to it. That way you will have all months, and whatever
payments may have happened.

-Tom.
Microsoft Access MVP
 
Back
Top