I have a vision for a database/gui web app that I am creating.
The functionality I'd like is this.
Have two or more list boxes that contain records of the databased sorted, and then with the other listbox organize by that data, in order to create charts and reports.
So for example, you would have 20 reason codes, and then select 1, and then choose a resolution code in the other box, to display a correlation. After doing this, you would be able to group those by date, and then by larger total.
Is access capable of doing something like this?