{"id":15195,"date":"2022-10-10T18:07:15","date_gmt":"2022-10-10T12:37:15","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/"},"modified":"2022-10-10T18:07:15","modified_gmt":"2022-10-10T12:37:15","slug":"solved-ms-access-get-quartilespercentage","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/","title":{"rendered":"[Solved] MS Access, get quartiles(percentage)"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-41644151\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"41644151\" data-parentid=\"41643391\" data-score=\"1\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>You don&#8217;t provide any sample data or expected results but &#8211; as the function can return one value only &#8211; you will most likely have to use the function in a subquery which you join to the main query on the field you group by in the main query. This way you will filter on the value you group by in the main query.<\/p>\n<p>This will give you the requested Quartile(s). Min, Max, and Median can be obtained with the native function of Access.<\/p>\n<p><strong>Edit<\/strong><\/p>\n<p>Actually, it could be something like this:<\/p>\n<pre><code>SELECT \n\u00a0 \u00a0 GroupByField, \n\u00a0 \u00a0 GetQuartile(\"YourTable\",\"ValueField\",1,\"GroupByField='\" &amp;\u00a0[GroupByField] &amp;\u00a0\"'\") AS Q1, \n\u00a0 \u00a0 GetQuartile(\"YourTable\",\"ValueField\",2,\"GroupByField='\" &amp;\u00a0[GroupByField] &amp;\u00a0\"'\") AS Q2, \n\u00a0 \u00a0 GetQuartile(\"YourTable\",\"ValueField\",3,\"GroupByField='\" &amp;\u00a0[GroupByField] &amp;\u00a0\"'\") AS Q3, \n\u00a0 \u00a0 \u00a0 (Select Avg(ValueField) \n\u00a0 \u00a0 \u00a0 From YourTable As T \n\u00a0 \u00a0 \u00a0 Where T.GroupByField = YourTable.GroupByField;) AS \n\u00a0 \u00a0 AvgValue\n\u00a0 FROM \n\u00a0 \u00a0 YourTable\n\u00a0 GROUP BY \n\u00a0 \u00a0 GroupByField;\n<\/code><\/pre>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">3<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved MS Access, get quartiles(percentage) <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] You don&#8217;t provide any sample data or expected results but &#8211; as the function can return one value only &#8211; you will most likely have to use the function in a subquery which you join to the main query on the field you group by in the main query. This way you will filter &#8230; <a title=\"[Solved] MS Access, get quartiles(percentage)\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/\" aria-label=\"More on [Solved] MS Access, get quartiles(percentage)\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[473,474,3458,3942],"class_list":["post-15195","post","type-post","status-publish","format-standard","hentry","category-solved","tag-ms-access","tag-ms-access-2010","tag-percentage","tag-quartile"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] MS Access, get quartiles(percentage) - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] MS Access, get quartiles(percentage) - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] You don&#8217;t provide any sample data or expected results but &#8211; as the function can return one value only &#8211; you will most likely have to use the function in a subquery which you join to the main query on the field you group by in the main query. This way you will filter ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-10T12:37:15+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] MS Access, get quartiles(percentage)\",\"datePublished\":\"2022-10-10T12:37:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/\"},\"wordCount\":108,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"ms-access\",\"ms-access-2010\",\"percentage\",\"quartile\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/\",\"name\":\"[Solved] MS Access, get quartiles(percentage) - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-10-10T12:37:15+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] MS Access, get quartiles(percentage)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] MS Access, get quartiles(percentage) - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] MS Access, get quartiles(percentage) - JassWeb","og_description":"[ad_1] You don&#8217;t provide any sample data or expected results but &#8211; as the function can return one value only &#8211; you will most likely have to use the function in a subquery which you join to the main query on the field you group by in the main query. This way you will filter ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/","og_site_name":"JassWeb","article_published_time":"2022-10-10T12:37:15+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] MS Access, get quartiles(percentage)","datePublished":"2022-10-10T12:37:15+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/"},"wordCount":108,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["ms-access","ms-access-2010","percentage","quartile"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/","url":"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/","name":"[Solved] MS Access, get quartiles(percentage) - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-10-10T12:37:15+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-ms-access-get-quartilespercentage\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] MS Access, get quartiles(percentage)"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775193939","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/15195","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=15195"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/15195\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=15195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=15195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=15195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}