Count certain values in areport

[rkaria]

Hi All

Im trying to edit a report that currently shows the number of warranties that have been claimed.

It currently show the total amount for each department. I am now trying to show the total count within each department which of those claims are assigned to a certain fault code. I.E 01A= no fault found, 14A = good arrived too late.

I have tried "select distinct count" but I imagine the coding is wrong and Im also not sure where the coding should go, within report? or within a querie?
I have tried selecting the fault code field and clicking on totals, but only one that is available is count records and count values, the other are greyed out. When I click on either of these 2 I just the total number of rows.

I am new to this so please let me know if more information is needed.

Oh I'm using access 07, but saving as compatible with access 03

Thanks
Rkaria

 

[jdraw]

I think you should be working with a query, not your current report. Work with a query that accesses the appropriate tables.

You could make a new report based on the new query.