Count

  • Thread starter Thread starter HaigyBhoy
  • Start date Start date
H

HaigyBhoy

i want to be able to count an item in a combo box so i know how many times
it has be selected for a client

i have a combo box with various items,
i open another form to show c balance for this particular item, ie £2000, i
need to know how many times this i have choosen the particlar item and show
it in a text box

can anyone help

hope my explanation is ok
 
Where does that selection from the combo box go? If it
goes into a table somewhere, you could do a totals query
on it to count how many times each particular selection
has been selected.

You can get info about totals queries from Access Help.
You'll need to use the GroupBy and Count options.

Hope this helps,
Crystal
 
Back
Top