By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,730 Members | 1,546 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,730 IT Pros & Developers. It's quick & easy.

Need report from Listbox with muliple values by each item selected

P: 2
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?
Jan 9 '15 #1
Share this Question
Share on Google+
3 Replies

Seth Schrock
Expert 2.5K+
P: 2,951
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.ItemsSelected Property to see how.
Jan 9 '15 #2

P: 2
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.

Jan 9 '15 #3

Seth Schrock
Expert 2.5K+
P: 2,951
Then group the results by the individual and you can get counts for each individual on the report.
Jan 9 '15 #4

Post your reply

Sign in to post your reply or Sign up for a free account.