To whom it may concern,
My output from a query in MS Access can be found in the attached file. I am trying to perform an operation in MS Access which takes the attached output (in table form) and allows me to calculate the percentage change in salaries between the most recent (see As_Of_Date) and the second most recent record for every individual listed. For example I need MS Access to compute the percentage change between Tom's salary on 3/11/2011 and 11/1/2010.
Any help would be appreciated.