HI Team,
I am just trying to learn the SQL and have one question.
In attached access file have single table where it contains fields(1) names and fields(2) comments.
1. name (ABC) repeated 5 times so the count of names should be 5 and in comments word "Yes" repeated 5 time for name abc count of comment should also be 5
2. name (XYZ) repeated 5 times so the count of names should be 5 and in comments word "Yes" repeated 4 time for name xyz count of comment should be 4
i am trying to achieve the above result using access query and for better understanding please have a look on the attached excel file.
Excel file : 1st sheet contains raw data
2 and 3 sheet contains the result/output using the counta and countif formula.
I request you to kindly advise how to achieve the expected result in access using query.
Please Note : Cross posted in below site as well.
link : https://www.excelforum.com/access-ta...ml#post5448050
Thanks in advance for all your help and support.