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!  🙂