Parameter Query/Report Question to Count Text

[Lettyg82]

I need to count the number of Female Defendants and number of Male Victims in a parameter query. The fields [DefSex] and [VSex] are text fields from a lookup column where F is female and M is Male. This report will be specific by date and specialist. I want the specialist, Kati Behrens (in the query the criteria for the field [Specialist] is set to Kati Behrens) to be able to pull up all of her cases from 08/01/12 (which is a parameter in the query).
In the query I created a field for [DefSex] which is FDEF: IIf([defsex]="F",1,0) and one for [VSex] which reads as VMALE: IIf([VSEX]="M",1,0)
In the report I put a text box that reads =sum([FDEF] and another =([Vsex])


However this gives me an error when I put it on the report footer. If i place these boxes in the detail section is calculates but it calculates depending on many Charges there are, if one case has 3 charges it counts 3 female defendants.
How can I get this field to count only once?
I can send snapshots of my report and query. Please help, I am new to access and am seriously confused. I am open to any suggestions.
Thanks

[June7]

One option is to use DCount in textbox ControlSource. The DCount would need the same criteria as in the query the report is based on.

DCount("*","Cases","DefSex='F' AND Specialist='Kati Behrens' AND CaseDate=#[Enter Date]#")

I don't use query input popup parameters. I use reference to form controls where criteria are input.

[Lettyg82]

That doesn't seem to work either. It still gives me an error message. I put the code you provided in a text box on the page footer and its just gives me an error.

[June7]

I would have to examine database. If you want to provide, follow instructions at bottom of my post.

[Lettyg82]

Here you go. I am having problems with the rptDismissedCases and LongSheetRPT, specifically having to do with the sum of things.

[June7]

Getting the table name correct helped. I couldn't read it from you snapshot image.

=DCount("*","Case","Dismissed = True AND DefSex='F' AND Specialist='Kati Behrens' AND CaseDate BETWEEN #" & [StartDate] & "# AND #" & [EndDate] & "#")

[Lettyg82]

Thank you so much, that fixed it!!