Record Count

[Jahangir]

Dear Frinds,
I want to count the number of records a query has returened. how I can do this in Ms access.
thanks.

[PEB]

Hi,

Dcount("*","You r query name", "")

:)

[Jahangir]

SELECT HeadCount.Animal, HeadCount.Gender
FROM HeadCount
WHERE (((HeadCount.Animal) Like "Cow"));

How can I integrate Count field in this query

[NeoPa]

Dim strSQL As String
strSQL = "SELECT HeadCount.Animal, HeadCount.Gender " & _
"FROM HeadCount " & _
"WHERE (((HeadCount.Animal) Like 'Cow'));"
DCount("*", strSQL)

You may want to mod your WHERE clause to say either " = 'Cow'" or " Like 'Cow*'" though.
Another issue to bear in mind, unless you're sure of the case use something like

"WHERE ((UCase(HeadCount.Animal) = 'COW'));"

[PEB]

Hey NeoPa you fly in the sky my frien :)

My frien try this one:

SELECT HeadCount.Anima l, HeadCount.Gende r, Count(HeadCount .Animal) AS Animals
FROM HeadCount
GROUP BY HeadCount.Anima l, HeadCount.Gende r
Having (((HeadCount.An imal) Like "Cow"));


:)