Help: Setting up Reports for Database

[Mark]

I have been using Excel for various databases through the years as an A.D.
in a high school. I use Excel for player files, schedules, inventories, etc.
I will be assigning umpires for a group doing HS fast-pitch softball this
spring and want to set up another database using the following columns:
Date, School System, Level, Visiting Team, Home team, Site, Time, Plate,
Bases, Played?, Rescheduled Date. I've posted all of the info and I'm ready
to set up reports.

Using the List Manager, I've done reports many times before but never used
the Report Manager function. I usually use the View function, set up
various views, and print from those. This time I want to have a separate
report for each school (visiting and home teams) with their games in
chronological order and do the same for each umpire. I can't figure out how
to conform the filter to give me an individual umpire and/or school with
their entire schedule and names above the report sheet (I guess somehow I
use the Header function for that). The same umpire may be assigned to the
plate in some games and sometimes to the bases. I can't get a report
together to do this by date.

Is this asking a bit much?

-Mark

 

[Jonck van der Kogel]

Hi,
Sounds to me like you are trying to do something that, though it may
be possible in Excel, would be a lot easier using any relational
database. Check out MySQL or PostgreSQL, both free and very powerful
databases that can do all that you described (and a heck of a lot
more) very easily.
All the best, Jonck