William Bell

Thanks again. This is a much more sensible approach. I got the idea of using summary fields from a book, but I might have misunderstood what they were getting at.

Thanks a million it works. Could I possibly pick your brains with a further question. There is also the possibility of insufficient enrollment in a class, in which case it will not run. If the minimum number is 6, I have used the count summary field for a calculation that returns "Insufficient Enrollment" if there are 5 or less students enrolled. This works up to a point, but the problem is that it does not change after the minimum number is exceeded. If you are busy I post this to the forum, and I promise I won't ask any more questions.

Thanks for the reply sorry I didn't get back sooner. Dropped my MacBook Pro. It's not as indestructible as it looks. -(

I have an enrollment database for classes and I need to inform people if they are in the class or on the waiting list for the class. As classes vary in size each class has a maximum number field and I have set up a summary field in the student/class join table to count the number of enrollments when sorted by class name. A third field then calculates if the summary is greater than the maximum number field. If not it gives "Enrolled" and if so it gives "Wait List". The problem arises when I want to find the records of students who are on the "Wait List". As summary fields are unstored I cannot find them. Is there a work around to make the data stored.

I am working on an Enrollment Database and I want to ensure that a student is not assigned a class that is not for his/her grade. To avoid entry errors I have a check box field in the Classes Table (06. 07. 08. 09. 10. 11. 12) of the database which the administrator checks when setting up the database. In the Students Table of the database there is a field with the student's grade e.g. 09 In the classes + students join table I would like a calculation field that reads the students grade and compares it to the check box field and returns either "OK" if the student is in the correct grade for the class and "Wrong Grade" if the student is in grade 9 but the class is for grades 10-12. As far as I can see there is no "Find "Text" in specified Field" type of function and I have tried using Filter, and Positon functions but without consistent success - if the students grade is the same as the first check box checked it works otherwise not. I'd appreciate any help on this that I could get.