Search results

  1. S

    Not exists

    How would write sql not exists code to find records of students who have not received earned awards? I need to look at each student (tblJPerAwardsPacesStatus.fldFamIDFK) who has a status of earned and/or awarded in the tblJPerAwardsPacesStatus.fldStatusIDFK. I want my query to return a list of...
  2. S

    Multiple-table query for form

    I made a query to be the source for a form. This query has five tables. Because I was having ambiguous join problems, I made a query from tblPeople, tblJoinPeopleXGroups, and tblPeople_1 (this last table is so that I can get "leader" out of the 01People table without conflicting with "group...
  3. S

    Format function for 2 numbers after the decimal/Account for nulls

    This question is separate from previous questions. I am intensely trying to finish up a database and have lots of questions as I have left everything I can't do to the end. How can I make the following function accommodate courses with anywhere from 3 to 19 tests? I did this one for a course...
  4. S

    Trying to create a function to calculate a grade

    Scenario: The class has 3 technique checks. If the student makes an A (11) or A- (10) on Tech1 and Tech2, then he won't take Tech3. If the student doesn't make an A or A- on each of the first two then he will take the third technique check. I need a function to use on a form (actually public...
  5. S

    Value in field changes in record I go to to what it is in record I am leaving

    Included on a form are 3 fields which contain letter grades for tests. And then three other fields which change the letter grades to number grades. If I enter or change a value in, say, the Test1 field of record 13, then asI cycle through the records after that, they change the value in their...
  6. S

    Automatically changing previously entered values when a related field is updated

    On my form (and in an underlying table and query), three of my fields are GradeLevel with a value such as "PSA" (preschool a.m.), GradeCaption with a value of "Preschool Morning", and the third field is GradeSort with a value of "001" because sorting on GradeLevel would not give my a list of...
  7. S

    How to not print a record for duplicates in the name field

    I need a timesheet for each student. These timesheets are preprinted. I only need to print the name of the student(trimmed) in the upper right hand corner of a timesheet--one timesheet per student. The student has a record in the database for each class he is taking. My problem is that if the...
  8. S

    Changing a field in a previous record based on this record

    How do I write code for this situation. I enter a record with the fields of SS, TermNumber, CourseNumber, Action, and Current Student (and others that don't matter to this question). The Action is registered. Then I enter another record with all the same values except that the action is dropped...
  9. S

    Print only records added since last print

    How can I print a report showing only information from records that have been added since the last time the report was printed? For example, I want to add students to the database as they register, and then each time a new lab assistant comes in he will print labels for added students. Is a...
  10. S

    Don't want to print duplicate names

    How can I get one report for a student if he is in the database several times? I have tried UniqueValue, UniqueRecord, and hide duplicates. I could group on last name and put the field in a group header, but then I don't get all the "Smiths." I can't get a trim to succeed in a group header. This...
Back
Top Bottom