I want to assign quartile values to records as shown in the attached file using Access 2010. The values to be used for this are shown in column D (percmedian), and the process must be repeated for each area. The attached file is only a sample; there are almost 280 areas and this process will be repeated multiple times for different fields in other tables. Some areas only have one or two records and I recognize those cannot be used. For now I just need to see how to create the process for one table.
I would like to populate the Quartile field (column E) with values of Q1, Q2, Q3, and Q4 (those with percmedian values > Q3). I can do this once I know how to calculate the values for each quartile.
I recognize this will probably be a multi-step process and would prefer to do it using update queries, but using VBA is fine as long as the code is not unusually long or complex. Any suggestions would be appreciated. 2012-CensusTractsByQuartile-Sample.xlsx