How do I use a query to count records in a combo box?

B

BenNeedHelp

I have a created a combo box with 4 different fields. I want to now create a
query that will total the number of selections that were made for each field.
When I use the sum query, I get one total. How do I get the total or count
each field seperately in the combo box.

Thanks,
Ben
 
M

MGFoster

BenNeedHelp said:
I have a created a combo box with 4 different fields. I want to now create a
query that will total the number of selections that were made for each field.
When I use the sum query, I get one total. How do I get the total or count
each field seperately in the combo box.
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

What are you talking about? There is only ONE selection in a ComboBox.

If you want to count the number of available selections use the
..ListCount property of the of the Combo Box & multiply by 4. E.g.:

dim intCount as integer

intCount = me!comboBoxName.ListCount * 4

Debug.Print "The number of fields = " & intCount

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRHIXFYechKqOuFEgEQIxLACggHmNqJn7cKCMF3c80+1qs1jWkUsAn3+5
i4VEFQdwCGu7xdyE/FpmYEh/
=Qpes
-----END PGP SIGNATURE-----
 
Top