select * ????? report problome

[hud]

I have created a database for maintenance Dept. I want to creat a report where the user selects Between [start date] and[end date] query in which the report will show the following details
1-during this period how many times each section reported problomes.


Drilling dept: 5
Fire dept :9
water dept: 0

I am Using Dcount and getting the above figers​

How can I list all of the above mentioned problomes as list with in the selected date in the Section detailed area

Start date Enddate Section Problom clearance
12/12/03 18/12/03 Drilling dept link cut yes
12/01/04 12/01/04 Drilling dept link cut No

right now Iam getting all the tabel listed in the subreport

Can some one help Please, I realy need this urgently, if there is any sample codes or links I will be greatful.

 

[ecniv]

Count function along with aggregated data in sql statements (to get counts)
Also, have a look at either:
- custom sql statement to put report data into a temp reporting table - base the report on this temp table
- Pointing the report dates periods to the form the users use
- Grouping function on the report design

 

[hud]

Count function along with aggregated data in sql statements (to get counts)
Also, have a look at either:
- custom sql statement to put report data into a temp reporting table - base the report on this temp table
- Pointing the report dates periods to the form the users use
- Grouping function on the report design

I am new to access, could you be more clear and if you have any examples , codes,or links, it will be greate.