Sorting is working correctly.
I am just keeping your names until I fully have a grasp on everything. I can always modify the names later.
I think I am ready for the reports.
If it's not too much trouble I do have one question on the activity table. How hard would it be to add an "Current" field with a "Yes/No" property that would determine whether it appeared on the drop down of the "Event" form? If it's too much for right now I can try to work that later on my own.
Thanks again for all the help you have given me to this point.