counting records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

Probably - try something like

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

as the control source of a form textbox.

John W. Vinson[MVP]
 
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


John Vinson said:
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
Click to expand...

Probably - try something like

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

as the control source of a form textbox.

John W. Vinson[MVP]
Click to expand...
 
Back
Top