Determining Maximum Number of Registrations

[NoMail4AMD64]

I'm putting together a simple Access database for a private University
Continuing Education program and have realized my knowledge is
slipping badly.

I want to determine when a class registration has reached the maximum
determined by the facilitator. Ffor the life of me I can not think of
a simple method.

During registration classes and students are entered into a form that
links the two together. I assume that in some fashion I need a query
that "COUNT's" the current number registered for the course but that
value needs to be compared to a maximum value that resides in the
course/class association.

Any suggestions please and thanks.

 

[Allen Browne]

Use DCount() to count the number of matching records.

If you don't have the maximum allowed showing in your form, use DLookup() to
read that value from the table.

DLookup() and DCount() both use similar arguments. For an explanation of how
to use them, see:
Getting a value from a table: DLookup()
at:
http://allenbrowne.com/casu-07.html

 

[NoMail4AMD64]

Thank you Allen.