Need direction, donno where to start

[Carri]

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]

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]

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]

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