Count question

[jazzscreamer]

Hi,
I'm trying to count on a form Client who's control source is the table Client. I am trying to count the number of times that an id# on my form occurs in the Visitation table. This query should show up in a text box on my client form. What is the best way to do this. Thank you for any help.

Joel

 

[RichO]

If you are looking for occurences of the same ID#, you could do this easily with DCount. You can use the expression as the control source for the text box on your client form.

=DCount ("IDNumber", "Visitation", "IDNumber = " & Me.txtIDNumber)

This is assuming that the field in your table is named IDNumber and the ID number control on your form is named txtIDNumber.

Access help describes this function quite well if you need further information.