i have two forms. one is for adding participants to the database. the other form is for adding "events" that participants have attended, which includes the event name, participant list, and date of event. 

within "events" there are several types of events to choose from that will be repeated over time, including "tutoring", "lunch meeting", "ski retreat", etc. ideally i would have used a dropdown for this field, however since dropdowns are not available for lookup fields it is simply a single line field.

there is an "event list" view, which shows each event, along with it's date and list of participants. 

there is also a "student list" view, which shows each student, along with a list of events attended.

here's what i need to do: display the names of all students who have attended a certain type of event (e.g. "tutoring") within a given date range, and a total # of hours they've attended the designated event type.

my test was to make a view based on the student list with the criteria to only show students who have "tutoring" in their list of events attended. however i cannot figure out how to have the dates for those events be filterable. and i also don't know how to sum the total number of hours for that type of event. 

this application is nearing the deadline for completion and this is the critical feature without which i won't be able to use zoho creator. any help is greatly appreciated. 

thank you,

ccbread