I have this cross tab qry that gives me data in the following format:

employee july aug sept

what i would like to do is to have a col between each month for variance and a col for the % of
that varience :

employee july aug change from % change spt chng from %chg
july - aug Aug - sept




TRANSFORM Sum(Detail.InvoiceAmount) AS SumOfInvoiceAmount
SELECT Employee.EmployeeName
FROM Master
INNER JOIN (Employee INNER JOIN Detail
ON Employee.EmployeeName = Detail.Person)
ON Master.CheckNum = Detail.CheckNum
WHERE (((Master.CheckDate)>#6/30/2003#)
AND ((Employee.Type)="m")
AND ((Employee.Ares) Is Null)
AND ((Master.ExpenseType)="amex"))
GROUP BY Employee.EmployeeName,
Employee.Type,
Employee.Ares,
Master.ExpenseType
ORDER BY Employee.EmployeeName,
Master.CheckDate
PIVOT Master.CheckDate;


any help aprreciated

~M<