amm,
i didn't use access i use SQL Server
try to use your Query Designer to create 2 views
the first will be your one that you said you can done.
vb Code:
SELECT COUNT(Custstatus) FROM <YourTableName> GROUP BY Custstatus
and the other is for
with out any Groupvb Code:
SELECT COUNT(Custstatus) FROM <YourTableName>
and inside your crystal Report i believe that you can use the two Views.
and then you can do
CountActive/CountRows






Reply With Quote