My Access SQL problem is solved. Access can’t do what I wanted to do but the folks at WinSwim modified their custom SQL query report to allow for error supression which solves the problem. I just can’t say enough about the excellent support from WinSwim.
I don’t know how most swim teams manage their swimmers but ours revolves around age groups. Everything is organized by age group, coordianted by age group, reported by age group, etc. I have been creating Win Swim Reports using Crystal Reports to present the data in the database in a format our team is used to seeing it it.
Working on these reports is the primary reason I haven’t made much progress on the plugin lately. Swim team is winding down, our last meet is tomorrow night and once the season is over I expect to be able to work on the plugin again. There are a number of things I’d like to implement while the experience is still fresh in my memory. If I wait I’ll probably forget why I thought something was a good idea! 🙂