Thanks Marsh,
I almost had it but not exactly! This worked!
Ya! Sorry for the confusion on the Production number example, typo error!
"Marshall Barton" wrote:
[Quoted Text] > BEBatTHP wrote:
>
> >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)
>
> --
> Marsh
> MVP [MS Access]
>
|