Creating custom reports

[Alidar]

I work for an answering service, and due to various reasons I was handed the project of creating a database for quality control reporting.

Details: 500+ accounts, each one has a message ticket using a combination of info fields that we take, taken from a group of 120+ unique field types (caller name, date/time, call back #, etc).

I have worked out how to create the database, and the data forms needed to input the information that I am tracking (the vast majority are binary YES/NO (showing if something was missed or not while taking the call).

The problem I am having is in creating reports. I need the ability to print reports showing the results from a specific date range selected at the time of printing the report. It would be nice if I can have the date selected (I'll take a weekly report for now, and can add monthly and yearly reports later on once I get my feet wet *grin*)

In these reports I would like to be able to have listings, with field names on the left, and days of week across the top, with each cell showing a sum.

EXAMPLE:
........................................MON TUE WEN THUR FRI SAT SUN
MISSING CALLER ........ 2 ...... 2 ...... 2 ..... 4 ...... 8 ..... 9 ... 5
MISSING LOCATION..... 3 ...... 7 ...... 2 ..... 9 ...... 5 ..... 2 ... 2
MISSING ADDRESS...... 5 ...... 3 ...... 2 ..... 1 ...... 3 ..... 7 ... 0
MISSING PROBLEM...... 9 ...... 9 ...... 2 ..... 2 ...... 0 ..... 1 ... 3

A further refinement that would be nice would be the ability to create graphs based on the above info, but I can save that feature for down the road.

Sorry that this is long winded, I've been pulling my hair out trying to get up to speed on this. If I can master the steps needed to produce the above, I can probably produce the other reports needed using the same methods.

Thanks in advance for any help!!

[Sliderule]

Alidar:

I sent you a PM ( Private Message ) . . . and . . . hopefully, you will read it and see if it helps as a start.

Sliderule