I am doing a small project (free) I have set up a sign-up site, section number, attendee name, number of hrs for that class. there will be 10 or so classes at this conference and I would like to get a total number of hrs that someone spends in all of the classes they attend.
class 1 is 3.75 hrs
class 2 is 4.25 hrs
so the total number of hours is 8 hrs
not really even sure how to start. something simple otherwise I guess I will just add them manually and edit the record.
I have 3 tables class attendees, class list, conference attendees. the class attendees table get the info from the other 2 tables, and adds a new record each time some one signs up. In the class attendee table I have a field for class hrs and 1 for total hrs but maybe I need the total hrs to go to the conference attendees table? That way I'm only updating I record. Hum Seems like this should be simple.
Thanks for any help.
Patti