Calculate Percentage of Total Count of Records
In today's video, I'm going to teach you how to calculate the percent of total count that each item makes up in any particular table. For example, I've got a table of projects. Each project has a status (planning, design, construction, quality control, and completed.) I want to know the percentage of projects in each status type.
Links
Keywords
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #fasttips, aggregate query, dcount, outer join, nz function, Query to get percentage of records in table, calculating a percent of total in a query, Adding a percent column to MS Access Query