Need report from Listbox with muliple values by each item selected

[chadhunt77]

I have a form that tracks individuals assigned to a task. I select the individuals from a list box that is multi-select. I need to run a report that shows how many times a person has been assigned to a task to work. Any suggestions?

[Seth Schrock]

And you want your report to include just the people that you have selected in the listbox? If this is the case, then you would build your query to include the fields that you want, and then have your WHERE clause use the IN keyword to match your individuals primary key field to the list of individuals selected. I believe that the only way to create this list is to use VBA to loop through the ItemsSelected property of the list box. See MSDN ListBox.ItemsSe lected Property to see how.

[chadhunt77]

Seth, thanks for the reply. I have them populating a report but would like them separated out so I can count how many times an individual worked to ensure the work load is spread evenly if that makes sense. I will give your suggestion a try to see if that will work.

Chad

[Seth Schrock]

Then group the results by the individual and you can get counts for each individual on the report.