edjski Posted February 5, 2001 Posted February 5, 2001 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
LiveOak Posted February 6, 2001 Posted February 6, 2001 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
Recommended Posts
This topic is 8961 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 accountSign in
Already have an account? Sign in here.
Sign In Now