Was driving home and realized where I went wrong with making the field a numeric one. Derp. Thanks again. Now off to get my Excel/PowerPivot updated to 64bit now that this table is over 2.1 million rows as of this morning.

Yeah, our whole team has screamed ourselves horse telling them that Access is not the solution that they are looking for. Maybe if oil prices go back up we will get some money to do this correctly.