I am trying to create a report where by I have a Start Date and a Total Value fields. The Start Date denotes the Contract Start Date and I want to spread this evenly over a 12 month period. For example I want to have a Contract that starts on 01/03/2002 and ends on 28/02/2003 for £10000.00. In each column (using a cross tab) I would want to show 833.33
Anyone have any ideas at all.
Anyone have any ideas at all.