you can use the [select][1] tool with python. It's easier if you first copy the joined attributes to your feature class table, but not necessary. here is a python snippet (assuming you work with a shapefile) for year in range(2000,2015): arcpy.Select_analysis(fc, fc[:-4]+str(year)+".shp", """ "Start" = """ + str(year) ) this query is designed for a numeric field. For text field you should put it between ' 's [1]: http://resources.arcgis.com/en/help/main/10.1/index.html#//000800000005000000