Search results

HI Thanks for your prompt reply The data I have: Name of students Classes Grades for each term/session Example Mary is in Nursery1, First Year , First Term: English - 60. %, Maths - 70% I hope I have explained myself better Thanks so much

Hello Everyone Please how can I plot a line graph for each students to show their progress in a term and per session in a class, in a subject. Something that can be visibly seen to know how a student is doing in a subject or in a class Thanks and hope to read from you soon Your help will be...

This is the query I joined with the crostab query This query is a query from multiple tables So it is like querying a query StudentID StudentName SubjectID TermID under the criteria like 'Third term' SessionID ClassID TeacherID Total Test1 Test2 Exam Total This is what my query looks like, the...

Thanks for the help so far am very happy Please how do I so it such that I can automatically count the total for the terms a student attended a subject and divide the total marks obtained by the count Example Mary attented maths test n exam 2nd and 3rd Tern only so when summing up for the...

Thanks so much You really helped me and am very grateful What I did in the other query was to set the criteria to Like Third* so it brings out only report with scores of third term only plus the summation of First and Second Term on seperate columns Thanks Thanks Thanks

Thanks so much for your prompt reply it really saved a lot of headache. It worked well and am really very grateful What I have now is Name. Subject, First, second , and Third term. Is there a way I can do it such dat my Third will show me the test score, exam score and total on the same report...

Hi everyone I am actually working on a school database and am having some issues any help will be greatly appreciated. I have a query to run students total marks per subject for a term. E.g Mary. First Term. English. 62 Mary. Second Term. English.78 For the third term report I want it to...

Good day everyone It has really been awhile I posted in this forum Please I have a form purchase order details, that I used to enter quantity of items purchased. I found out that I can't delete quantities entered on the form. It appears to delete, but on checking the quantity in the inventory...

Good day Sir/Ma Please I have a subform in my order details form and I want to be able to delete records from the subform so I inserted this code in command button of the subform Private Sub btnDelete_Click() Call DoCmd.RunCommand(Command:=acCmdDeleteRecord) End Sub After clicking on the button...