Display count of fields in form.

[TimE]

Is it possible to have a count of all records matching a certain criteria displayed on the form?

I have to schedule customers for certain dates but never know how many have been scheduled by date while in the form. I am not sure how to reference the field from the table to be counted. I have several unbound boxes with:

=date()&" "&{XXXX}([SCHEDULE DATE]=date()
=date()+1&" "&{XXXX}([SCHEDULE DATE]=date()+1
=date()+2&" "&{XXXX}([SCHEDULE DATE]=date()+2
etc.

not sure what to use for {XXXX}

As always, any help is appreciated.....

Someday I will contribute some answers instead of questions.....

 

[pbaldy]

You could use DCount(), more info in Help.