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.

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.

Thank you Allen.

On Sat, 11 Nov 2006 13:00:50 +0800, "Allen Browne"
<(E-Mail Removed)> wrote:

>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