Results 1 to 2 of 2
  1. #1
    rockovo is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2018
    Posts
    3

    Count row percentage between different tables

    Hello,



    I got stuck on something that seems quite simple but I cannot figure this out..
    I scouted a lot for an example but my SQL/VBA skills are so basic that if I found it, I didn't recognise it.

    In this situation I've got 2 tables.
    - First table "TrainProc", contains training information of employees including "Category" of a procedure that they have been trained on.
    - Second table "Procedures", is a list of all procedures with another "Category" column for reference.

    My aim:
    I need to calculate percentage value of completed training.
    If for example, an employee has a count of 2 records in "TrainProc" table for a category that has count of 5 in "Procedures" table, then it should return 40%.

    Any advice?


    Thanks!!

  2. #2
    Minty is offline VIP
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Cross posted here https://www.access-programmers.co.uk...d.php?t=302465

    @OP please have a read here : https://www.excelguru.ca/content.php?184
    Thank you.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

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

Similar Threads

  1. Percentage of Count (text) data in Access Query?
    By Antoine_Tokyo in forum Access
    Replies: 1
    Last Post: 11-28-2017, 08:51 PM
  2. Query for Count and Percentage
    By aparnawangu in forum Queries
    Replies: 4
    Last Post: 12-11-2015, 01:12 AM
  3. Percentage calculation using two tables
    By vthompson9100@gmail.com in forum Queries
    Replies: 8
    Last Post: 04-16-2015, 02:18 PM
  4. Replies: 6
    Last Post: 02-23-2014, 03:54 PM
  5. Percentage based on Count
    By bryanwank in forum Access
    Replies: 1
    Last Post: 09-19-2012, 08:22 PM

Tags for this Thread

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