Jump to content

Creating Reports


This topic is 8502 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 8502 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.