way to count object in combo box using between dates

  • Thread starter Thread starter Heygrippet
  • Start date Start date
H

Heygrippet

I have a combo box with a list of 6 objects. When I ask to count each of the
object it works but when I asked to count between dates for each quarter it
does list all the occurences of an object instead of a count.

What would be a way do count instead of getting a list even though I
selected the function Count

thank you
JoHanne
 
I have a combo box with a list of 6 objects.  When I ask to count each of the
object it works but when I asked to count between dates for each quarter it
does list all the occurences of an object instead of a count.

What would be a way do count instead of getting a list even though I
selected the function Count

thank you
JoHanne
Click to expand...

only way I can think of doing it is using a query, which would mean
you would have to use a table/query for the combo box's row source.
Then you could use BETWEEN in your query and it should work.
 
Back
Top