Counting certain field for certain dates

[TammyT]

The report is displaying survey data for a 1 month period.

In the page header there are 2 rows of text boxes to display each day in the month - top row shows the weekday (format ddd = Mon, Tue, etc); bottom row shows the date (format m/d = 4/15, 4/16, etc).

Also in the page header are 4 text boxes that total the following:

- grand total surveys completed (all calls - (unavailable + refused)
- grand total surveys not available
- grand total surveys refused
- grand total all calls

What I also need to display is the daily total of surveys (same 4 types as above). I know I need 4 rows of text boxes to go under my date rows - 1 row for each of the total types; I'm just unclear as to what goes in those text boxes to get the totals!

My available field list contains:
- Date (of the survey)
- Ticket# (unique survey identifier)
- Employee name (not good to use, as not all employees are surveyed each month, & some employees are surveyed multiple times)
- Unavailable (yes/no data type)
- Refused (yes/no data type)
- D0 through D30: column headings in the crosstab query that is used to create this report. They are also the data on which the date text boxes are based.

Did I leave out any pertinent info?

Thanks!

+Tammy