Count Field on a Form

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

Guest

I would like to display the number of customers signed-up already on a form.
I cannot use a count statement because customers are signing up for different
dates. Is there a way to show the number of records based on another field on
the form i.e. (the date field) with the criteria of the date field entered on
the form? Thanks.
 
BarryC said:
I would like to display the number of customers signed-up already on a form.
I cannot use a count statement because customers are signing up for different
dates. Is there a way to show the number of records based on another field on
the form i.e. (the date field) with the criteria of the date field entered on
the form? Thanks.
Click to expand...

If you already have the correct number of records in a continuous form
(something you can get by filtering on that date), you can set the
controlsource of a textbox to:

=Forms!ThisFormName.Recordsetclone.Recordcount

where ThisFormName is the name of your form.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top