I know this is simple but I am still a newbie (I am however good at excuses!)

I need a record count formula. I need a count of all {Warrant.Warrant_Type} that = “WA” but that also where the {Warrant.Warrant_Disposition} = “Active”. It accepts this without error but only generates a “0” value on the report.

Does this make sense?

Yes I do. We keep a list of all warrants active or complete (Still pending service and already served). I am trying to do a running count or each type of warrant separately (Arrest Warrant, Bench Warrant, and Courtesy Summons Warrant).

Until I get this worked out I am running a report that filters out all "Complete" and groups by type with a total between groups.

It still gives a 0. Would that not wind up giving a count for all warrant types that are active?

Table:
     Warrants
Fields:
     Warrant Type
          AW – Arrest Warrant
          BW – Bench Warrant
          CS – Courtesy Summons Warrant

     Warrant Disposistion
          Active – (Still trying to serve)
          Complete – (either served by officer of canceled by clerk of court)

I want to put a record count of each “warrant type” that is set as “active” in the {Warrant Disposition} Field in the database.
I have a report that lists all active warrants and I have them grouped it by {Warrant Type} with a count at the end of each group. I just wanted to put a count in the report header so that I no longer needed to group the warrants by type. The report is easier for the officers to use when it is not grouped.

I am not sure why I didn't think to do it like that. I will give it a try! Sorry It used to be set to WA but to make it more uniformed I switched it to AW. Old habits! ;) Thank you very much for your help!

PS. So I do need to use "or" instead of "and" ?

Edited by ClantonC - 11 Jun 2015 at 4:24am