E
Edna Floyd
I have three seperate queries to calculate a percentage
of yes to no. The first query counts the yes and the
second counts the nos. The third query divids the yeses
and no to come up with a percentage of the yesses to nos.
The query is grouped by quarer and year. The queries work
good except for one month there was not any yesses to
count and the report does not show 0%. I have tried Nz
and DCOunt but I am unsure where to put this at or how to
use them. I tried to place them in the SQL statement but
I received repeated errors. Any help would be
appreciated.
of yes to no. The first query counts the yes and the
second counts the nos. The third query divids the yeses
and no to come up with a percentage of the yesses to nos.
The query is grouped by quarer and year. The queries work
good except for one month there was not any yesses to
count and the report does not show 0%. I have tried Nz
and DCOunt but I am unsure where to put this at or how to
use them. I tried to place them in the SQL statement but
I received repeated errors. Any help would be
appreciated.