Heh. Just throw my previous question away. lol I messed up. Now to fix your problem to the best of my knowledge...
Open your form in design mode.
Click the Sorting and Grouping button in your toolbar.
(or right click and goto Sorting and Grouping)
In the field expression select the appropriate date field.
Click the Group On field and select yearly.
That should group all of your dates by year. Now your only problem is to get it to do it for your fiscal year. I am not sure exactly how you could go about getting an answer for that.
I hope that has helped you some... let me know how it goes maybe I will come up with something else .
Okay cool that is getting me someplace. I will try and figure out how to get the date for the fiscal year. Now I just have one more question.
My seminars are ordered by their type. and there are 5 or 6 types. Now for each date period I want it to just display each seminar type once then show the total number of attendees for all of the seminars of that type. I run into a problem though when I include the date information because it will show each seminar type once for every seminar. This make any sense? How do I get around this?
I guess I want to be able to look at the records date info but not include it or something.. AHH. . so confusing