I have lots of experience creating queries in Access; now I'm learning Crystal XI. Getting distinct records in Crystal is making me crazy!

I generally create two types of queries: one for "cases" and the other for "clients." Counting cases is easy. Getting demographic data on clients is harder because clients can have multiple cases. Typically, I need to get demographic data for clients who have cases opened or closed within a specific time period.

I created a query in Access to get distinct client ids from cases opened within the last week. Then I tried to do the same thing in Crystal. I managed to get distinct ids in Crystal but the count was off by 1. I've looked and tried everything I can think of, but I cannot figure out why I'm getting just one duplicate client id. There are other duplicate client ids in the data set, but only one makes it into the Crystal output.

Any ideas?

Thanks,
Jessie

This was ridiculously easy once I was able to put aside my Access mindset and start thinking more like a Crystal Report. Thanks for helping!