import arcpy
FIPS = "C:\\Users\\D2148\\Documents\\Maps\\FIPS"
c = 0
# FIPSlist = ('001', '003', '005', '007', '009', '011', '013', #Try smaller list first
#'015', '017', '019', '021', '023', '025', '027',
#'029', '031', '033', '035', '037', '039', '041',
#'043', '045', '047', '049', '051', '053', '055',
#'057', '059', '061', '063', '065', '067', '069',
#'071', '073', '075', '077', '079', '081', '083',
#'085', '087', '089', '091', '093', '095', '097',
#'099', '101', '103', '105', '107', '109', '111',
#'113', '115', '117', '119', '121', '123', '125',
#'127')
#FIPSnum = (001, 003, 005, 007, 009, 011, 013, #Try Smaller list first
# 015, 017, 019, 021, 023, 025, 027,
# 029, 031, 033, 035, 037, 039, 041,
# 043, 045, 047, 049, 051, 053, 055,
# 057, 059, 061, 063, 065, 067, 069,
# 071, 073, 075, 077, 079, 081, 083,
# 085, 087, 089, 091, 093, 095, 097,
# 099, 101, 103, 105, 107, 109, 111,
# 113, 115, 117, 119, 121, 123, 125,
# 127)
FIPSlist = ('001', '003', '005')
FIPSnum = (001, 003, 005)
while c < len(FIPSlist):
for fip in FIPSlist:
query = "FIPS_PARIS ='" + fip + "'"
# arcpy.TableToTable_conversion("TRIAL1",FIPS,"FIPS" + FIPSlist + ".dbf",query)
arcpy.TableSelect_analysis("Master_TAHI", FIPS + "\\FIPS" + FIPSlist + ".dbf",query)
c = c + 1
I think this will work as it was trying to work and made the first file correct. However, it will not loop anymore