Creating a Report with multiple counts

[Aloupha]

Hello,

I am trying to create a report that would display multiple counts of records per column values within a specific date range.

My table is as follow:

DATE	UPDATE_TYPE	COVERAGE_TYPE	NOTIFY_SOURCE	USER
01/01/2013	MANUAL	TYPE 1	EMAIL	TS
01/01/2013	SYSTEM	TYPE 2	REPORTS	TS
01/01/2013	MANUAL	TYPE 2	ANALYSIS	TS
01/02/2013	SYSTEM	TYPE 1	CALLS	TS
01/01/2013	SYSTEM	TYPE 2	EMAIL	TP
01/01/2013	MANUAL	TYPE 2	ANALYSIS	TP
01/10/2013	MANUAL	TYPE 1	REPORTS	TT
01/15/2013	SYSTEM	TYPE 2	EMAIL	TA
01/13/2013	SYSTEM	TYPE 1	REPORTS	TS

I would like for the user to enter the date range when opening the report (I can do that part). If a user ran the report for 01/01/2013 - 01/31/2013, I want to see the result as follow:

UPDATE TYPE

MANUAL	4
SYSTEM	5

COVERAGE TYPE

Type 2	5
Type 1	4

NOTIFY SOURCE

EMAIL	3
REPORTS	3
ANALYSIS	2
CALLS	1

I guess my issue is I don't know how to add the count query to give me the result I seek.

[June7]

Use IIf expressions in textboxes in group or report header/footer.

Sum(IIf([Update Type]="Manual",1,0)

Sum(IIf([Update Type]="System",1,0)

[Aloupha]

Use IIf expressions in textboxes in group or report header/footer.

Sum(IIf([Update Type]="Manual",1,0)

Sum(IIf([Update Type]="System",1,0)

Thanks! that's exactly what I was looking for. I kept trying to do it with count().