Carri Posted December 4, 2008 Posted December 4, 2008 Need to Calculate the number of classrooms needed: I need to calculate the number of classes that take place in given time slots and I don't know where to even start. Any advise would be much appreciated. Classes are scheduled at 00, 15 , 30 ,45 past the hour We need to analyse our room needs Thanks in advance
mz123 Posted December 4, 2008 Posted December 4, 2008 Can you.... Create a table called Times Create a time field called "Time" Add a record for all possible class times. Create a relationship between the table Times and Classes by Time Create a summary field in Classes which is a Count of the Class Serial Number (or the Time) Show the related summary field on the Times layout, next to the Time field. Thoughts?
mr_vodka Posted December 4, 2008 Posted December 4, 2008 This can be built but another option is to possible take a look at a prebuilt product and see if it helps. http://seedcode.com/cp-app/ste_cat/filemakercalendar
Carri Posted December 8, 2008 Author Posted December 8, 2008 This was great thanks. Got me off to a good start, just need to work out to do it for every date separately, Thanks
Recommended Posts
This topic is 5888 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now