I need help creating a report.

The database is for keeping track of ticket sales thru a variety of outlets for tour dates.

The report must display the number of concert tickets sold by the different outlet types (bookstores, churches, radio, etc.) in different cities that are part of a tour 'run' of dates.

I want it to look like this:

RUN [March]

OUTLETS CITY1 CITY2 CITY3

outlet type1

outlet type2

outlet type3

I am having trouble getting the report to sort and display the data.

It could be that I am clueless......

THanks,

Ed

I have no idea what's a field in your example! If you sort by outlet type,have a field called Tickets Sold for each type, create a summary field Total that is the total of tickets sold, and create a subsummary part when sorted by Outlet Type, you will get a total for each outlet. -bd