Breakdown of individual items from listbox in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a listbox with a choice of 5 items. How can I get Access to count the
number of entries for each item?
 
When you say "count the number of entries for each item", do you mean you
have a table with multiple rows, and in each row you have a field/value that
corresponds to one of the items in your listbox? This is a "reports"
newsgroup -- are you saying you have a listbox in a report?
 
information is inputted on to a form and from this compiled into a Table ie
choose colour - red, yellow, green, blue, black, I am trying to get a
breakdown of numbers for each colour from the table.
 
Take a look at a Totals query, GroupBy Colour, Count a field like the rowID.

Regards

Jeff Boyce
<Access MVP>
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Cannot select items in listbox 1
selecting listbox items 1
Query using multiple listbox selections 5
How to Populate Data from a table to another 0
size a listbox dynamically 2
List box for reports 1
Listbox in Reports 2
Dynamic report using listbox 2

Back
Top