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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dcount in report with 2 criteria only works individually, not with 5
Count 3
Report Query Question 1
counting records 0
A03 - count in report footer gives me #Error? 0
Showing records based on status 4
Help with Iif on Report 4
Excel VBA - counting cells by colors and names to it in two different rows. 0

Back
Top