Changing Report Format - Header/Side Fields

[net123]

I created a report that displays the correct data by displaying a sum of fields for certain days. I more-or-less looks like this:

============================================
Summary Data - Between Date1 and DateN
--------------------------------------------
Field1 Field2 Field3 Field4
--------------------------------------------
Day1:
------
Totals: 3 5 9 2
--------------------------------------------
Day2:
------
Totals: 8 3 4 5
--------------------------------------------
Grand Tot: 11 8 13 7
=============================================
[/blue]

But what I want is for the fields to be on the side and the dates on top. Sort of like this:

============================================
Summary Data - Between Date1 and DateN
--------------------------------------------
Day1 Day2 Day3 DayN
--------------------------------------------
Field1: 3 5 9 2
--------------------------------------------
Field2: 8 3 4 5
--------------------------------------------
Field3: 2 1 5 8
--------------------------------------------
Field4: 5 8 3 5
--------------------------------------------
Grand Tot: 18 17 21 20
=============================================
[/red]

Can this be done?

 

[fredk]

I would think a crosstab query would work in this situation.

Fred

 

[net123]

No, that didn't work either... Thanks

 

[dhookom]

You might need to create a UNION query that "normalizes" your data. Then create a crosstab query based on the union query.