05/01/18 VPOP PROJECTIONS USING BY2014v2BMV VEHICLE POPULATIONS

1.) Import the V2_2014_BMV_VPOP_ALL.xlsx into an Access database.
2.) Import the most recent MDOT VMT into the same database.(VMT112817) 2016 Actual VMT with projections to 2045 
3.) Query the V2_2014_BMV_VEHPOP table.
4.) Query the MEDOT_VMT table selecting 2014 as the criteria.  These two queries are to pull the 2014 vehicle population and 2014 VMT to create the ratio of 2014VPOP/2014VMT in step #5.
5.) Create a query to bring in the VPOP and VMT from step 3 and 4 into a table.  Create a new field to devide 2014 VPOP by 2014VMT.  
6.) Create a query to select the MEDOT_VMT table and use the selection criteria to select the VMT for the year that you wish to project the VPOP out too.  Example Use 2017 in the criteria for the VMT YearID if you want to project VPOP out to 2017.  This will set up the queries to preform the followning 2017 VEH Population Projections = (2014VEHPOP/2014VMT) * 2017VMT
7.) Create a query to bring in the VEHPOP/VMT from step 5 and VMT from step 6 into a table.  Add another field to calculate out the (2014VEHPOP/2014VMT)*2017VMT.
8.) Create a query to make a county table.
9.) Create a query to bring in the County ID into a table with the 2017VPOPPROJ.
10.)  Create a cross tab query to place county populations in 16 columns rather than in row formats. 