Reports and Check Box List Sorting

[Cornerdjh]

I have a list of checked box items that I want to be able to sort for each of them and produce the other data that goes along with them. I have all the fields in one table and I'm not sure what steps or how to go about to create the report I want.

Example:

Check boxes are Orange, Apples, Tangerines, Grapes

Information I want to include in my report - growth location, type of fruit, date, grower.

I want to be able to have a pop-up window that the user can select which fruit the report should be sorted by and then produce the report with the title of the report that prints whatever fruit they selected along with the information shown.

Thanks in advance.

 

[jasmith4]

Please post the table's structure and some sample data.