field grouping

[dott]

I have created a report which groups by year and then by location as follows:

YEAR1
.................LOCATION1
...................................................DATA
.................LOCATION2
...................................................DATA
.................LOCATION3
...................................................DATA
YEAR2
.................LOCATION1
...................................................DATA
.................LOCATION2
...................................................DATA
.................LOCATION3
...................................................DATA

But, here's how i want it to be:

......................YEAR1............YEAR2.....
LOCATION1....data...............DATA......
LOCATION2....data...............DATA......
LOCATION3....data...............DATA......

 

[llkhoutx]

What you want is a crosstab query as the recordsource for your report.

 

[mark curtis]

pop on the db and it will be looked at, if you wish?