Rotate Report 90 Degrees

[Bella's Mom]

I keep a database for a local cemetery association. I'm trying to create a report that will visually look like the cemetery lots/plots. For Example, Section A, Lot 1 has 8 Plots. A-1-A, A-1-B, A-1-C, A-1-D, A-1-E, A-1-F, A-1-G, and A-1-H. Currently, my report lists the data from top to bottom. A-1-A at the top with the corresponding data listed horizontally. A-1-B listed underneath, with the corresponding data listed horizontally.



I want A-1-A with all it's data listed underneath it. Then a 2nd column to the right with A-1-B , with all it's data underneath. So A-B-C-D-E-F-G-H left to right across the top. Then NAME, then DOB, then DOD, etc. listed underneath.

That way when someone is standing south of the headstone, the data will read left to right as you're looking at the plots.

If I could rotate my entire report 90 degrees, I could rotate my text and make it work.

Is it possible? Am I missing something simple?

[June7]

No, this will not be simple. You want to 'transpose' the data (essentially de-normalizing) - Excel can do this easily with copy/paste Transpose option.

In Access this is commonly accomplished with a CROSSTAB query or (prior to Access 2013) a pivot table - but in your case a single CROSSTAB won't get it done. I think will need a CROSSTAB for each field (name, DOB, DOD, etc) then a UNION query to merge them. Like:

query DeceasedName
TRANSFORM First(Table1.DeceasedName) AS FirstOfName SELECT Table1.Section, Table1.Lot, "DeceasedName" AS DataType FROM Table1 GROUP BY Table1.Section, Table1.Lot, "DeceasedName" PIVOT Table1.[Plot];

query DOB
TRANSFORM First(Table1.DOB) AS FirstOfDOB SELECT Table1.Section, Table1.Lot, "DOB" AS DataType FROM Table1 GROUP BY Table1.Section, Table1.Lot, "DOB" PIVOT Table1.[Plot];

query DOD
TRANSFORM First(Table1.DOD) AS FirstOfDOD SELECT Table1.Section, Table1.Lot, "DOD" AS DataType FROM Table1 GROUP BY Table1.Section, Table1.Lot, "DOD" PIVOT Table1.[Plot];

SELECT Section, Lot, DataType, A, B, C, D, E, F, G, H FROM DeceasedName
UN ION SELECT Section, Lot, DataType, A, B, C, D, E, F, G, H FROM DOB
UN ION SELECT Section, Lot, DataType, A, B, C, D, E, F, G, H FROM DOD;

[IrogSinta]

What is the maximum number of plots you'd have in each section? Fitting 8 columns is fine but would you have a section that needs 20 columns?

Ron