Count Quantity of a Sub Form

[jboyle]

I have a subform that contains city, state and store name. I want to count how many stores are in the sub form.
Example:
Miami Fl store A
Orlando Fl store B
Orlando Fl store B
Orlando Fl store B
=======================
I want the count of stores which would be 2. Any help would be appreciated. John Boyle

 

[Rich]

Only way I can think of is a query with Unique values set to yes using DLookUp if you want it displayed on the main form.
HTH