multiple date counting (1 Viewer)

[russi]

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

 

[Rich]

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

 

[russi]

Thanks, Rich!
Worked great.

Russ