A Running Total or Number

[lesterd]

I have a sign-up list for space usage that is limited to 12 people per period on the current date. There are 10 possible periods to sign up for during the day. (Periods 1,2,3,4a,4b,4c,5d,5e,6,7) The layout is called Space Sign Out

I would like the to show either a running total of sign-ups left or the number already signed up for each period on the layout, Space Sign Out.

I have attached the file in case you need to look at it. I have left only a small number of people in the file to reduce the size. There are usually 3000 student records.

P.S. I am also trying to limit the number of times a person sign up to use the center to 2 times per week (7 day span).

Thanks

BHS_Pass_copy_2.fp7.zip

Edited September 11, 2006 by Guest