Access Filter Question

[David Chain]

In Access I am trying to filter out the details but want to still get an overall total. What is the best way to do this.

Reporting on how many Audits an agent does, but I only want to show the errors that they have made. But when I filter out the errors, I can no longer get the overall total.

I have 30 audits completed for a given period and there are 3 errors. If I filter it on the error then I can only get the three line, but cant get the overall 30 for my total.

Please help.

David

[RuralGuy]

Have you considered a DCount() for the total value?

[David Chain]

so how would you write this code out?

=dcount([Claim #]<1,1,0) ???

or what would you do?

[RuralGuy]

All of the arguments to the DCount() function are strings:

http://www.mvps.org/access/general/gen0018.htm