Report

[Udayan]

Sir,

I made a quiry which contains the following fields
Status
On status I made a criteria "On Duty"

Nationality
On Nationality I made a Critera "Indian"Or"Filipino"

and showing the result correctly

My Question is
in the Report I can count the total report by formula
=Count(*)

and also showing the total result correctly

Is there any way to show how many Indian's and howmany Filipino's in that
record, if so how

Kinldy request to help in this matter.

Thanks

 

[KARL DEWEY]

Try this (UNTESTED) --
= Sum(IIF([Nationality] = "Indian", 1, 0))
and
= Sum(IIF([Nationality] = "Filipino", 1, 0))