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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dtecta

    Calculating Sums from a Combo Box or Check Box

    If it weren't for you, I would NEVER have figured this out. Actually, the only way I could get it to work was to put those Iff statement in the underlying query. Without doing that, the report wouldn't let me sum the text boxes in the footer because it saw those field names as parameters - I...
  2. dtecta

    Calculating Sums from a Combo Box or Check Box

    Yes, the count of each type of status in each separate class.
  3. dtecta

    Calculating Sums from a Combo Box or Check Box

    Thank you! It works perfectly when I only have one class per report. What happens if I want to have more than one class on a report and I have the report sorted and grouped by ClassID? How do I get the control to give me the status of students in each class?
  4. dtecta

    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...
  5. dtecta

    Code for checking one box to fill in 10 others

    Thank you both for your expert advice... it works like a charm. Bob - GO STATE! I graduated from MSU in 2000 with my M.A. in Communication. I appreciate your assistance.
  6. dtecta

    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...
  7. dtecta

    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...

Part and Inventory Search

Back
Top