the sample data is missing the field that specifies location (ie: Nationwide, Irvine, and Kansas City)

see attached
Database1.accdb

what you want to do cannot be done with a cross-tab query alone. What I would do is loop through the records using VBA for each location and write the results to Excel or Word -- and I would recommend Excel since formulas are easier -- and it can also pivot information.

I would generally agree with Crystal, although you can create a crosstab query which would return headings like:

Nationwide|FY16     Nationwide|FY17         Nationwide|Variance     Irvine|FY16        Irvine|FY17       Irvine|Variance

The way to do this is to concatenate two field ([Location] & "|" & "[Year]) in the query column you designate as "Column Header".

However, this would probably involve generating the crosstab query against a union query, which is what you would need to compute the data for your [Variance] columns and to compute your Total Dispositions row at the bottom.

I don't have access to the database now (on my iPad), but will take a look at your later this evening.

LVL48 - thanks sounds like a potential solution

I did something similar.... Thanks