Search results

  1. M

    Solved FILTER BY FORM

    Thanks for going an extra mile. I don't take it lightly. Thanks also for your explanations. I really appreciate.
  2. M

    Solved FILTER BY FORM

    You are very funny but I appreciate your help.
  3. M

    Solved FILTER BY FORM

    I will redo it again
  4. M

    Solved FILTER BY FORM

    It is my wish to make the best database. If there is a problem help me please.
  5. M

    Solved FILTER BY FORM

    Thanks for your help though I can't figure out the problem from the table
  6. M

    Solved FILTER BY FORM

    Getting confused 😧
  7. M

    Solved FILTER BY FORM

    Oh ok. I guess there is a way to filter one Student per SUBJECTS DONE. Mmmmmmm. That could be of help
  8. M

    Solved FILTER BY FORM

    I don't know if the problem lies in query 3 because the Subjects are not filtered meaning a student who sits for exams in term 1 and term 2 and term 3 all subjects entered will be printed even if you filter. Please
  9. M

    Solved FILTER BY FORM

    Kindly check the subreport. I am defeated for sure
  10. M

    Solved FILTER BY FORM

    Still I get 8 Subjects TERM 1 1. AGRICULTURE-50 2. CHEMISTRY- 60 3. ART AND DESIGN- 90 4. AVIATION- 80 5. BIOLOGY- 60 6. AGRICULTURE- 80 7. BIOLOGY- 90 8. BIOLOGY- 100 IF YOU CHECK AT THE FORM: YEARS-2020 CLASS- FORM 1 STREAM- NORTH TERM- TERM 1 Examination type- CAT 1 SHOULD BE: 1...
  11. M

    Solved FILTER BY FORM

    I am still new to Ms access. This forum has really helped me. Let me try though I don't know how to use debug.print
  12. M

    Solved FILTER BY FORM

    Hello everyone. This forum has really helped me. I really appreciate. Kindly look at the attached database. I am trying to filter records by form. Look at the form "frmStudents" and form "print Report forms" When you filter from drop-down for example Year- 2020 Class- form1 Stream-north Term-...
  13. M

    Solved Finding the mean of Students based on mean of subjects

    That is a different thread.
  14. M

    Solved Finding the mean of Students based on mean of subjects

    I am trying to filter but it still gives me the report the way it is. I want to filter per the Student
  15. M

    Solved Finding the mean of Students based on mean of subjects

    Thanks.
  16. M

    Solved Finding the mean of Students based on mean of subjects

    I have database of 50 Students. Students can select and do subjects which they wish. I have 5 subjects namely SUBJECT A, SUBJECT B, SUBJECT C, SUBJECT D, SUBJECT E. I know the easiest way of finding class mean is =Avg([Marks]). However, I want add mean of subjects done, add the mean and divide...
  17. M

    FILTERING REPORTS

    Kindly, I am requesting anyone to assist me with a sample database with OpenReport method. Thanks. Merry Christmas and Happy New year everybody.
  18. M

    FILTERING REPORTS

    How? Private Sub Report_Open(Cancel As Integer) ? ? End Sub Please help
  19. M

    FILTERING REPORTS

    In a form the filter works perfectly. I am defeated on how to use it on a report.:- Private Sub Command221_click() Form.Country.SetFocus DoCmd.RunCommand acCmdFilterMenu End Sub I now need it to apply in a report so that the user can print only certain names e.g People from New York, USA only.
  20. M

    FILTERING REPORTS

    How are you doing everyone? I have a question? How do you filter a report from a tables which the user entered the fields manually? For example: Name. City. Age John brown. New York. 35 John brown. Oxford. 40 In this case john brown is from usa...
Back
Top Bottom