Report

  • Thread starter Thread starter Udayan
  • Start date Start date
U

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
 
Try this (UNTESTED) --
= Sum(IIF([Nationality] = "Indian", 1, 0))
and
= Sum(IIF([Nationality] = "Filipino", 1, 0))
 
Back
Top