Recent content by Serendipityww

I have not gotten anything to work. When a student earns an award, he/she gets a record in the database with status of "earned." Then when that same student with that same paceID gets the award, he/she gets another record in the database with status of "awarded." I want a list of all students...

How will I get a list of all students who meet the criteria, if I am specifying a specific student id?

I put this in SELECT Count(*) FROM tblJPerXAwardsPacesStatus WHERE fldFamIDFK = 503 AND fldFamIDFK = 3 and got the result of 3512 under a column heading of Expr1. Also, when I ran the query, it asked me for values for fldFamIDFK and fldFamIDFK. I didn 't get a list of student who have a...

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

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

Thanks. I will try it. By calling it, you mean put an = in front of AvgGrade([Factor],[Tech1],[Tech2],[Tech3]) and put it as the control source for the control that gets the result?

I do have those tables. Does that make it a simple issue? Thanks

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

Still need more help, please. I now have the form based on a query which is based on 4 tables. The values should store back in the Grading table, but I still have my original problem. Because I couldn't update via the form, I set the Recordset Type to Dynaset(Inconsistent Updates). Could this...

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

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

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

I got it. I didn't realize that I had to "close up" the detail section. Thanks for your help.

I am grouping on name (tried it with SS too), specified a group header for the name field, and then put my name field in that group header. All records are still printing. I want only one record for each student, regardless of how many times they are in the database. What am I doing wrong? Thanks.

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