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

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?

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

This was great thanks. Got me off to a good start, just need to work out to do it for every date separately, Thanks