Getting a Distinct Count from Crystal

I may be tired and just thinking about this the right way, so I am turning
to the NG's for help....

I have a database with visitors to a center. Although they login in one
table, there is another table that captures each visit.

The report I need is a count of those persons that visit only once and never
come back again exclusive of those that visit more than once.

For example, if "John" visitied on Monday and tha was the only time he came
in, he would be in an unduplicated list. Then "Mary" visted every day this
week, so she would be in the duplicated list.

I have tried grouping by name, the counting the instances of a date/time
stamp on the visitor table, then selecting onling those equal to "1", but
cannot then SUM that Count.

Any help is appreciated....

--
John C. Harris, MPA
JCZ Consulting Services, LLC

"The trouble with the world is that the stupid are cocksure and the
intelligent are full of doubt"
-- Bertrand Russell


.