The following data as an example (excluding the desired result column)
comes from an Access database. I need for excel to calculate what
employees actually salary recieved during the financial year of April
1 to 31 March.

What I want is to be able to get a user to click a button on Access
which will take them to a pivot table which displays what employees
actually received each financial year. This pivot table will be linked
to a (hidden) excel sheet where the figure has already been calculated.
As it will be a hidden sheet, I need for excel to do this
automatically but I can't figure out how to do get this figure without
manually manipulating the excel sheet cells.

I also have two things that need to be looked into ... How do we
calculate a total figure if someone received numerous salary increases
in the same financial year (see Steve Bilington 1998/1999). Also, what
do we do if there has been no salary increase one year (see Steve
Billington is missing a figure for the 2002/2003 financial year as he
received no increase that financial year. I need for excel to
recognise this but calculate a figure for that missing financial year
as I still need it to appear in the pivot table.

I dunno what to do!!!! HELP!!!!!!!!!!!! K/

FirstName LastName Salary£ FinYear Date Inc DESIRED RESULT
Steve Billington 75000 1998/1999 1-Apr-98 0
Steve Billington 100000 1998/1999 1-Jun-98 0
Steve Billington 130000 1998/1999 1-Oct-98 Sum of £ received in
1998/1999 fin yr
Steve Billington 132500 1999/2000 1-Oct-99 £ received in fin year
Steve Billington 136000 2000/2001 1-Oct-00 £ received in fin year
Steve Billington 151000 2001/2002 1-Oct-01 £ received in fin year
Steve Billington 160000 2003/2004 1-Oct-03 £ received in fin year &
figure for 02/33
Steve Billington 165000 2004/2005 1-Oct-04 £ received in fin year
Steve Billington 175000 2005/2006 1-Oct-05 £ received in fin year
Bob Anderson 70000 2005/2006 1-Apr-05 £ received in fin year
David Downes 100000 2002/2003 1-Oct-02 £ received in fin year
David Downes 114500 2003/2004 1-Oct-03 £ received in fin year
David Downes 127500 2004/2005 1-Oct-04 £ received in fin year