I have a table with 3 fields, one for each of 3 goals that could be reached by clients.
There are corresponding dates.

I need a query that will count the number of clients who have a value in the date field.
I tried individual and then doing a crosstab but it didn't work correctly.
What am I missing?

thanks.

Russ

Totals Query:Group By Clients, Count DateField, Not Is Null in the criteria of your date field.

Thanks, Rich!
Worked great.

Russ