Search results

  1. I

    MONTHSSS

    There is a need. Kindly assist me.
  2. I

    MONTHSSS

    In tblA we have BANANASID and in tblB we have BANANASID. We have a field in tblA bananas and in tblB bananas. I don't want to keep repeating typing BANANAS in tblB after writing in tblA
  3. I

    MONTHSSS

    Thanks for your reply. My database is designed in a way that there are some fields that are the same in tblA and tblB for the purpose of normalization tables. If you could help me on how if I write in a field in table A THEN the same information is populated in tblB I will be very grateful...
  4. I

    MONTHSSS

    I have two related tables let's call them 1. tblA. 2. tblB. Is there any way such that if I write in a field in tblA to be populated automatically in tblB? E.g if I write BANANAS in tblA then in tblB I will see BANANAS without me writing anything in tblB. Thanks in advance.
  5. I

    CREATE OVERLAY MENUS

    It is showing all forms. How do I hide other forms and reports...?
  6. I

    CREATE OVERLAY MENUS

    Hahahaaa. My bad. I should have quoted you. You did good work. Thanks so much
  7. I

    CREATE OVERLAY MENUS

    Thanks sir. I would appreciate if there was a demo
  8. I

    CREATE OVERLAY MENUS

    Thanks
  9. I

    CREATE OVERLAY MENUS

    I greet you all. I am kindly requesting for assistance in creating overlay menus just like in the attached screenshot below. I would like such that if you click lets say object type it opens another form. when a form is opened the menus should not disappear. Thanks in advance.
  10. I

    Solved DYNAMIC REPORT FROM CROSSTAB QUERY

    Hi @arnelgp how can I print only 7 best perfomed Subjects from this crosstab query. Kindly have a look at qryGrades.
  11. I

    Solved DYNAMIC REPORT FROM CROSSTAB QUERY

    I have found the answer after updating qryGradeSubjectGrouped. Thanks to you guys I have been assisted so much in this forum 👏👏👏👏👏👏👏👏👏👏👏👊👊👊👊👊
  12. I

    Solved DYNAMIC REPORT FROM CROSSTAB QUERY

    Is there any way where after entering a record for a student cannot be duplicated in the report??? I am seeing as per the code i<=24 will not work because duplication might need 200 labl
  13. I

    Solved DYNAMIC REPORT FROM CROSSTAB QUERY

    @arnelgp this Report has a slight problem. Supposing a school has TEN STREAMS and all Students are doing a Subject let's say English. The Report will have 10 columns and in every column all Students doing English will be duplicated 10 times. It works fine when you filter per the stream but if...
  14. I

    Solved DYNAMIC REPORT FROM CROSSTAB QUERY

    You are genius. My database is complete thanks to you. God bless you so much. It works perfectly 💪💪💪💪💪💪💪🏼💪💪🏼💪💪💪💪💪👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻👏🏻
  15. I

    Solved DYNAMIC REPORT FROM CROSSTAB QUERY

    The logic behind this is that if you want to get CLASSMEANSCORE you sum the Meanscore of Subjects done divided by the subjects done which will give us 50.83333. Then in Excel we use IF as I have shown. Kindly assist me now in ms access based on database. Thanks in advance.
  16. I

    Solved DYNAMIC REPORT FROM CROSSTAB QUERY

    Ignore the other one and use this one. Check on the "RED"
  17. I

    Solved DYNAMIC REPORT FROM CROSSTAB QUERY

    Kindly check this updated excel workbook sir
  18. I

    Solved DYNAMIC REPORT FROM CROSSTAB QUERY

    Kindly check sir
  19. I

    Solved DYNAMIC REPORT FROM CROSSTAB QUERY

    This is what I get when try to upload an extension with xls. Kindly inbox me your email address.
  20. I

    Solved DYNAMIC REPORT FROM CROSSTAB QUERY

    Here it is sir
Back
Top Bottom