Results 1 to 6 of 6
  1. #1
    WCStarks is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2016
    Posts
    314

    Calculating percentages of participation in events

    I originally posted this incorrectly under Forms, so I am repeating it here.

    I have master tables: Members Table, and Events table, and an Activities child table associating Event participation by Members. From the Events perspective, I can see all who participated in that event, and from the Members perspective, I can see all events each member participated in.

    The Activities child table contains, among other data, the Event Type and the Member names, along with the linking pointers to the parent Event and Members tables records. I need to count the total of each event type and total of each type which each of the members participated in. Then I need to display those totals and calculate the percentage participation for each event type for each member. I expect I can do this by counting the events of each type in the Events table and the Activities child table. I am sure it is not all that hard, but being somewhat awkward at this, I am struggling to see just how to do this in a report, to produce stats for each of multiple event types.

    Any suggestions how best to do this?

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    You seem to be developing along a trial and error path with a physical database.
    That's an approach, but can be time consuming and frustrating when "issues" arise that require fundamental design changes.

    You have told us about your tables, and are asking about how to do/implement certain detailed business processes using Access. You really haven't told us about the requirement in non-database, non-technical terms. A good and complete description of the business, a sample of desired outputs can often simplify design and development. Here's a link that may be useful.

    You also seem to have a well laid out set of tables and relationships. Have you tried to isolate your specific requirement to the tables involved and, using pencil and paper, try to get your "algorithm/logic" to work. Like making a blueprint before building the building.

    Good luck with your project.

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I deleted your duplicate thread. In the future if you want to move a thread just press the triangle and make the request. All of the moderators will get the message.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    As for an answer to your question(s), Reports make several passes before actually printing so they can sum a field for you and you can use that value to divide each of the values for a percentage. Give it a try.

  5. #5
    WCStarks is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2016
    Posts
    314

    Post

    Thanks for cleaning up my blunder. Concerning the calculation. I am having a hard time wrapping my mind around the needed query or queries.

    1) I have a table of Events of various types (categories). I need to do a count for each category, to use as a divisor for that category. I see this as one Query.
    2) I need to process the members and count how many times they participated in each event category, and provide a participation percentage of each Event category for each member, even for events they did not participate in. I imaging this would be a second query.
    3) I can see what the report would look like. It would list each member, with an indented list of event categories, with participation counts and percentages.

    Would you be interested in outlining how I might do that.

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You will learn more if you give it a try yourself. The Report is pretty good to get you started. Grouping and sorting ar controlsed *only* by the report so you feed it a query that includes all of the records you want and then dictate the grouping and sorting in the report.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Trying to get percentages
    By UT227 in forum Queries
    Replies: 2
    Last Post: 09-17-2017, 12:00 PM
  2. Degree of participation
    By jaydubya in forum Access
    Replies: 5
    Last Post: 11-21-2016, 01:41 PM
  3. Percentages
    By sdel_nevo in forum Forms
    Replies: 1
    Last Post: 03-27-2014, 03:13 AM
  4. percentages
    By sdel_nevo in forum Programming
    Replies: 10
    Last Post: 06-05-2013, 01:00 PM
  5. Replies: 3
    Last Post: 05-23-2013, 05:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums