Search results

  1. G

    Solved FILTERING MAIN REPORT AND SUBREPORTS FROM A FORM

    Looks like there are no sample databases. If there is one kindly please assist me have a look on how to filter REPORTS and subreports. Thanks
  2. G

    Solved FILTERING MAIN REPORT AND SUBREPORTS FROM A FORM

    Thanks. Any sample database. Ir could assist me and other new members a great deal
  3. G

    Solved FILTERING MAIN REPORT AND SUBREPORTS FROM A FORM

    Hello. Kindly please if anyone has a sample database on how to filter subreports whether numeric fields or text fields kindly assist me. I will really appreciate. Please. Please. Please. Kindly assist me please.
  4. G

    Solved FILTERING MAIN REPORT AND SUBREPORTS FROM A FORM

    Ki Kindly assist me on how to filter subreports after filtering the main report. Please i am begging you. Please.
  5. G

    Solved FILTERING MAIN REPORT AND SUBREPORTS FROM A FORM

    They are linked but when you filter the main reports it gives all records in subreports. How do I filter records in subreports. Numeric and Text Assist me please
  6. G

    Solved FILTERING MAIN REPORT AND SUBREPORTS FROM A FORM

    I have corrected that. Kindly assist me with vba code to call Report and subreports from a form
  7. G

    Solved FILTERING MAIN REPORT AND SUBREPORTS FROM A FORM

    Hello everyone. I have main report with two subreports. From the form, when I filter using ID, it gives me all the records including all the records in subreports. The query for subreport A is query 1 and for subreport B is query 2. If i want to see records for customerID 1, on goods he bought...
  8. G

    Solved Grouped ranking

    Th Thanks to you I have found the solution. Thanks so much.
  9. G

    Solved Grouped ranking

    It works. However I am defeated to insert the number of students who did exams. Should be CLASSRANK: 1 OUT OF (NUMBER OF STUDENTS WHO DID EXAMS.) E.G MILLICENT CHEPKOECH CLASSRANK: 1 OUT OF 7 FORM 1 WEST 2022
  10. G

    Solved Grouped ranking

    Let me replace the query qryAllMarks with QueryTotalMarks. I appreciate your efforts. Thanks
  11. G

    Solved Grouped ranking

    Thanks so much. Sum of mark should be grouped.
  12. G

    Solved Grouped ranking

    You are complicating even further. I have been working on it for the last two weeks without success. Kindly look at the attached database and assist me. It has given me headaches.😭😭😭😭😭😭😭😭😭😭😭😭😭😭😭😭😭😭😭😭😭😭
  13. G

    Solved Grouped ranking

    Someone kindly assist me
  14. G

    Solved Grouped ranking

    Stream Position......(out of Students in a stream)
  15. G

    Solved Grouped ranking

    Hi. Check REPORT FORMS in REPORTS in this database. I need a query or function to rank Students per class and per the stream at a certain year and a term e.g Year- 2022 Term- Term 1 Student Name- X Class position..... Out of ...........(Students in a class) Stream Position....... Out of(Students...
Top Bottom