I have a few thousand transactions in an Access 2010 DB. Each is assigned to one of about a dozen categories. The categories are listed in a separate table. I need to be able to list in a report all the transactions in one or more categories which the user chooses at run-time.
Doing this for a single category, via a combo box listing all the categories, is straightforward but I've not found a way to manage this for multiple selections.
I'd like to have a form which lists all the possible categories with a checkbox adjacent to each one. The user can then check which of the categories he/she requires. This info would be used to generate the report.
No doubt this problem has arisen many times - I've just failed to find the answer. Any pointers in the right direction would be appreciated.
TIA John
Doing this for a single category, via a combo box listing all the categories, is straightforward but I've not found a way to manage this for multiple selections.
I'd like to have a form which lists all the possible categories with a checkbox adjacent to each one. The user can then check which of the categories he/she requires. This info would be used to generate the report.
No doubt this problem has arisen many times - I've just failed to find the answer. Any pointers in the right direction would be appreciated.
TIA John
