counting records

[Dennis Wolf]

I have formed a query and based a form on it. Is it possible to count e.g
the number of males, females that occur in this query without referring to
the main database but just to the query/form.
thanks
Dennis

 

[John Vinson]

I have formed a query and based a form on it. Is it possible to count e.g
the number of males, females that occur in this query without referring to
the main database but just to the query/form.
thanks
Dennis

Probably - try something like

=DCount("*", "[queryname]", "[Sex] = 'F'")

as the control source of a form textbox.

John W. Vinson[MVP]

 

[JohnW]

John Vinson

Thanks for this. It worked just like I needed. Your tips are always
helpful and east to understand for a novice like me.

John W.
--
JCW

I have formed a query and based a form on it. Is it possible to count e.g
the number of males, females that occur in this query without referring to
the main database but just to the query/form.
thanks
Dennis

Probably - try something like

=DCount("*", "[queryname]", "[Sex] = 'F'")

as the control source of a form textbox.

John W. Vinson[MVP]