I have never used DCOUNT but Help says that the first argument should be a
field name.


"Dblosevn" wrote in message
...
I am getting an #Error message

I copied and pasted the text and changed the particulars to this:

=DCount("*","[qryStartsTbl]","[Contact Feedback] = 'Not Called'")



"Wayne-I-M" wrote:

Not really sure if I understand what you are looking for but I "think"
you
are looking to count the number of times a specific string appears in a
field
in the query that the form is based on ???

Use this is the source of an unbound text box in the form footer
=DCount("*", "[QueryName]", "[FieldName] = 'Something'")

Let me know if this is what you need as there are other methods

--
Wayne
Manchester, England.
Enjoy whatever it is you do


"Dblosevn" wrote:

I am trying to place a footer on a form which counts a subset of the
records
that the form displays based on one of its fields. The form uses a
query to
display its data which is extracted from company mainframe and updated
nightly. The query and forms break down the data by day and workgroup.
I want
to be able to display the number of records counted by one of its
fields
which is a drop down list and restricts user to a limited number of
selections.