G
Guest
Hi
I have a Rehab Schedule Table, that lists the class name, date started, Max
class size, etc. RehabID is the PKey, connected to the Schedule Table. In
the schedule table, this is where all the data on each client is captured.
So... there would be the schedule table with client name, address, etc. Then
the subform has the class name, date, time, cost, etc. The Rehab ID is used
in the subform to choose which class this person is registering for.
What I am needing to do:
In the Rehab table, the data will be entered like this: Pilates, Sept 1
(StartDate) 8 (MaxClassSize). When I am in the schedule and select this
class, I would like access to count the number of times that this class
StartDate has already been selected.
If I can get it to count the number of occurances, then I can do an iif
statement stating "Register this class" or "Class full, Register next class".
But.... I can't get to this point until I figure out the best way for the
date count.
Thanks for any help
I have a Rehab Schedule Table, that lists the class name, date started, Max
class size, etc. RehabID is the PKey, connected to the Schedule Table. In
the schedule table, this is where all the data on each client is captured.
So... there would be the schedule table with client name, address, etc. Then
the subform has the class name, date, time, cost, etc. The Rehab ID is used
in the subform to choose which class this person is registering for.
What I am needing to do:
In the Rehab table, the data will be entered like this: Pilates, Sept 1
(StartDate) 8 (MaxClassSize). When I am in the schedule and select this
class, I would like access to count the number of times that this class
StartDate has already been selected.
If I can get it to count the number of occurances, then I can do an iif
statement stating "Register this class" or "Class full, Register next class".
But.... I can't get to this point until I figure out the best way for the
date count.
Thanks for any help