I'm using crystal xi (ver: 11.5.0.313) to report against an Access 2003 database.  I cannot modify the database as it is part of another project.   I have created a query (4 tables joined) which I am reporting against.

 

One of the columns returned by my query is called [Species] and may contain "Dog", "Cat", Null or an empty string. 

 

I need to  know what percentage of records contain the word "Dog" in the species column.  I had thought that this would be a very simple function containing a variant of the count() function but I cannot find an example anywhere that allows me to specify a constraint to be used with the count().

 

I suspect that this may be very simple and I'm missing something quite simple & obvious. I do hope so anyway

 

If anyone can point me in the right direction I would be very grateful

 

cheers - gb

 

I'll try the cross-tab method you suggest.  I've not used it before but hopefully I'll find an example somewhere.

 

Cheers - GB

 

Thanks for that Brian, I'll certainly checkout the material you suggest. If crystal does becomes a regular task I  think i'll probably need that book   cheers - guy