I need to build an Access 2007 report for comparing property sales. The field names are PropertyName, CityName, Community,SqFt, LotSize, Age, DateSold, Price. The report will need to be a side by side comparison where the user selects the properties to be compared and the report will have the labels (field names listed above) on the left side of the report and all the data going across for each property. So the report headings will be PropertyName and then all the attributes are listed below each property name. I was able to do this using page setup, columns across, then down, and having all the report controls going down the length of the report, but the report wants to print the labels for each property, and I only want the labels displayed once, on the left side.
I thought about trying to build a traditional report, then flip everything 90 degrees and reformat all labels and textboxes but I dont see a way to do that.
Is there an easier way to do this?
Thanks!
I thought about trying to build a traditional report, then flip everything 90 degrees and reformat all labels and textboxes but I dont see a way to do that.
Is there an easier way to do this?
Thanks!