Adding up dates for a total

[Guest]

I have a database that I am tracking testing status of customers and need to
add a total to a report. I would like to get a total number if customers that
have a date in a particular status. Example:
Contacted Testing Approved Production
Customer A 01/01/06
Customer B 01/05/06 01/10/06
Customer D 02/15/06 02/20/06 02/25/06 02/25/06

Total 3 2 1 2

I have the report that displays each status and it's date but what I can't
get is a "Totol" of each stats that has a date

Any help would be greatly Appreciated!
Brian

 

[Marshall Barton]

I have a database that I am tracking testing status of customers and need to
add a total to a report. I would like to get a total number if customers that
have a date in a particular status. Example:
Contacted Testing Approved Production
Customer A 01/01/06
Customer B 01/05/06 01/10/06
Customer D 02/15/06 02/20/06 02/25/06 02/25/06

Total 3 2 1 2

I have the report that displays each status and it's date but what I can't
get is a "Totol" of each stats that has a date

The word "total" implies a sum. It appears that you want to
count the number of dates, but your "total" fot production
doesn't agree with that either.

Assuming that you do want the count of non-Null dates, use
text boxes in the report's footer section and set each text
box's control source expression to:
=Count(Contacted)
=Count(Testing)
=Count( Approved)
=Count(Production)

 

[Guest]

Thanks Marsh,
I almost had it but not exactly! This worked!

Ya! Sorry for the confusion on the Production number example, typo error!