count of values

[Clemens]

I know there must be a simple solutions for this, but I fail over and over
again:

I have a table and 1 field is 'Status' In this field there can be 4
different values.
I want to create a report which displayes the count per value
value 1 = open,
value 2 = closed

I have created a query which reports the amount of each value, but I failed
to create a report based on more than 1 query.

How can I create a report with all the counts I wish for?

 

[Dennis]

Create 4 text boxes on your report, The control source for each should be

=DCount("Status","YourTableName","Status = 'Open'")

Changing the back part each time to the relevant status text.
(Don't forget the single quotation marks around Open, Closed etc.)

 

[Ken Sheridan]

Take a look at the current thread:


http://www.microsoft.com/office/com...06-a084-f67d1bce7589&cat=&lang=&cr=&sloc=&p=1


which also relates to conditional counting. In that there are only two
possible values, but the principle is exactly the same, you sum the return
value of an expression which returns 1 or 0, e.g.

=Sum([Status] = "open", 1,0))

Ken Sheridan
Stafford, England

 

[Ken Sheridan]

Opps! That should have been

=Sum(IIf([Status] = "open", 1,0))

Ken Sheridan
Stafford, England