Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Calculating Sums from a Combo Box or Check Box
I have a "Status" combo box in my Query and Form that has three options: "Withdraw," "Needs to Make Up," and "No Show." I would like to be able to calculate a separate sum for each of those options. For example, if I have 2 students in the class whose...- dtecta
- Thread
- Replies: 7
- Forum: Microsoft: Access Reports
-
Code for checking one box to fill in 10 others
Does anyone have a suggestion for a macro or code for a form whereby if the user checks a particular check box to mark a student as having completed the course(CourseCompl), ten other check boxes on the form for attendance will automatically fill in (Module1, Module2,...) Thanks in advance for...- dtecta
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
-
Append data to one field in subform
I am working with a subform that tracks student scores for each item in a developmental inventory. Because I wanted to attach information to each item (age level), I set up the tables like this: Items: ItemID (e.g. DFM-01, DFM-02, etc.) Item DevAge Scores: AssessmentID ItemID Score...- dtecta
- Thread
- Replies: 0
- Forum: Microsoft: Access Forms
