I am trying to create a report that looks much like a spreadsheet. Such as this:
Location1 Location2 Location3
label1:location1data...location2data...Location3da ta
label2:location1data2...etc....etc

They would like to only see the label once and the data in columns across, much like an Excel spreadsheet. I have tried working with cross tab queries some, but I have over 50 fields that will need to be listed below each location. Can anyone suggest anything?

Open report ind design view.
Click on "File", "Page Setup", "Columns".
You'll find here what you need.

Thank you for the reply, but I have already tried that. In order to only have one label this option does not work. Thanks anyway.