Using Count

[Guest]

Hello,

I have a form based on one query. The query filters out the data that I
want to see on my form. I want to use the Count function to count the number
of records based on the field "Area". Also, based on the field "Status".
For example, I want to see how many records there are for [Area] "South" that
has "High" in the [Status] field.

Can I create a text box and use the Count or DCount function to do this?

 

[Duane Hookom]

Use something like:
=Sum( Abs([Area]="South" AND [Status]="High"))