Multiselect text to report
Question from a QB newbie. I am creating a form for patient bags we give out to patients. I have it set up asking the following questions: Date given (date), Patient name (text), Contents in bag (multiselect text with each of the items- chapstick, icescraper, phone charger etc). The goal of this form will be to keep track of who has received bags but more importantly to track how much of each item we are using each month. For example, we put chapsticks in each bag. So for the month of October we want to be able to see how many chapsticks we've given out for ordering purposes. Does anyone have any ideas on how to make this work in a report? I am having issues getting the report to reflect that information. Is there a better way to set this up?
