I'm trying to split a table into multiple tables. The code I'm using is the following but I keep getting a syntax error in querey expression.
SELECT [2004 Retail].NAIC, [2004 Retail].[ZIP Code], [2004 Retail].[Total Establishments], [2004 Retail].[1-4], [2004 Retail].[5-9], [2004 Retail].[10-19], [2004 Retail].[20-49], [2004 Retail].[50-99], [2004 Retail].[100-249], [2004 Retail].[250-499], [2004 Retail].[500-999], [2004 Retail].[1000 or more] INTO 441120
FROM [2004 Retail]
WHERE (([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers"))
SELECT [2004 Retail].NAIC, [2004 Retail].[ZIP Code], [2004 Retail].[Total Establishments], [2004 Retail].[1-4], [2004 Retail].[5-9], [2004 Retail].[10-19], [2004 Retail].[20-49], [2004 Retail].[50-99], [2004 Retail].[100-249], [2004 Retail].[250-499], [2004 Retail].[500-999], [2004 Retail].[1000 or more] INTO 441210
FROM [2004 Retail]
WHERE (([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers"))
SELECT [2004 Retail].NAIC, [2004 Retail].[ZIP Code], [2004 Retail].[Total Establishments], [2004 Retail].[1-4], [2004 Retail].[5-9], [2004 Retail].[10-19], [2004 Retail].[20-49], [2004 Retail].[50-99], [2004 Retail].[100-249], [2004 Retail].[250-499], [2004 Retail].[500-999], [2004 Retail].[1000 or more] INTO 441221
FROM [2004 Retail]
WHERE (([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers"))
SELECT [2004 Retail].NAIC, [2004 Retail].[ZIP Code], [2004 Retail].[Total Establishments], [2004 Retail].[1-4], [2004 Retail].[5-9], [2004 Retail].[10-19], [2004 Retail].[20-49], [2004 Retail].[50-99], [2004 Retail].[100-249], [2004 Retail].[250-499], [2004 Retail].[500-999], [2004 Retail].[1000 or more] INTO 441222
FROM [2004 Retail]
WHERE (([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers"))
SELECT [2004 Retail].NAIC, [2004 Retail].[ZIP Code], [2004 Retail].[Total Establishments], [2004 Retail].[1-4], [2004 Retail].[5-9], [2004 Retail].[10-19], [2004 Retail].[20-49], [2004 Retail].[50-99], [2004 Retail].[100-249], [2004 Retail].[250-499], [2004 Retail].[500-999], [2004 Retail].[1000 or more] INTO 441229
FROM [2004 Retail]
WHERE (([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers"))
SELECT [2004 Retail].NAIC, [2004 Retail].[ZIP Code], [2004 Retail].[Total Establishments], [2004 Retail].[1-4], [2004 Retail].[5-9], [2004 Retail].[10-19], [2004 Retail].[20-49], [2004 Retail].[50-99], [2004 Retail].[100-249], [2004 Retail].[250-499], [2004 Retail].[500-999], [2004 Retail].[1000 or more] INTO 441310
FROM [2004 Retail]
WHERE (([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores"))
SELECT [2004 Retail].NAIC, [2004 Retail].[ZIP Code], [2004 Retail].[Total Establishments], [2004 Retail].[1-4], [2004 Retail].[5-9], [2004 Retail].[10-19], [2004 Retail].[20-49], [2004 Retail].[50-99], [2004 Retail].[100-249], [2004 Retail].[250-499], [2004 Retail].[500-999], [2004 Retail].[1000 or more] INTO 441320
FROM [2004 Retail]
WHERE (([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers"))
and oh yeah....thanks for all the help I've gotten on this forum, I love the prompt replies that I keep getting. THANX GUYS! AND GALS!
SELECT [2004 Retail].NAIC, [2004 Retail].[ZIP Code], [2004 Retail].[Total Establishments], [2004 Retail].[1-4], [2004 Retail].[5-9], [2004 Retail].[10-19], [2004 Retail].[20-49], [2004 Retail].[50-99], [2004 Retail].[100-249], [2004 Retail].[250-499], [2004 Retail].[500-999], [2004 Retail].[1000 or more] INTO 441120
FROM [2004 Retail]
WHERE (([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers") AND ([2004 Retail]![NAIC]="441120 Used car dealers"))
SELECT [2004 Retail].NAIC, [2004 Retail].[ZIP Code], [2004 Retail].[Total Establishments], [2004 Retail].[1-4], [2004 Retail].[5-9], [2004 Retail].[10-19], [2004 Retail].[20-49], [2004 Retail].[50-99], [2004 Retail].[100-249], [2004 Retail].[250-499], [2004 Retail].[500-999], [2004 Retail].[1000 or more] INTO 441210
FROM [2004 Retail]
WHERE (([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers") AND ([2004 Retail]![NAIC]="441210 Recreational vehicle dealers"))
SELECT [2004 Retail].NAIC, [2004 Retail].[ZIP Code], [2004 Retail].[Total Establishments], [2004 Retail].[1-4], [2004 Retail].[5-9], [2004 Retail].[10-19], [2004 Retail].[20-49], [2004 Retail].[50-99], [2004 Retail].[100-249], [2004 Retail].[250-499], [2004 Retail].[500-999], [2004 Retail].[1000 or more] INTO 441221
FROM [2004 Retail]
WHERE (([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers") AND ([2004 Retail]![NAIC]="441221 Motorcycle dealers"))
SELECT [2004 Retail].NAIC, [2004 Retail].[ZIP Code], [2004 Retail].[Total Establishments], [2004 Retail].[1-4], [2004 Retail].[5-9], [2004 Retail].[10-19], [2004 Retail].[20-49], [2004 Retail].[50-99], [2004 Retail].[100-249], [2004 Retail].[250-499], [2004 Retail].[500-999], [2004 Retail].[1000 or more] INTO 441222
FROM [2004 Retail]
WHERE (([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers") AND ([2004 Retail]![NAIC]="441222 Boat dealers"))
SELECT [2004 Retail].NAIC, [2004 Retail].[ZIP Code], [2004 Retail].[Total Establishments], [2004 Retail].[1-4], [2004 Retail].[5-9], [2004 Retail].[10-19], [2004 Retail].[20-49], [2004 Retail].[50-99], [2004 Retail].[100-249], [2004 Retail].[250-499], [2004 Retail].[500-999], [2004 Retail].[1000 or more] INTO 441229
FROM [2004 Retail]
WHERE (([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers") AND ([2004 Retail]![NAIC]="441229 All other motor vehicle dealers"))
SELECT [2004 Retail].NAIC, [2004 Retail].[ZIP Code], [2004 Retail].[Total Establishments], [2004 Retail].[1-4], [2004 Retail].[5-9], [2004 Retail].[10-19], [2004 Retail].[20-49], [2004 Retail].[50-99], [2004 Retail].[100-249], [2004 Retail].[250-499], [2004 Retail].[500-999], [2004 Retail].[1000 or more] INTO 441310
FROM [2004 Retail]
WHERE (([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores") AND ([2004 Retail]![NAIC]="441310 Automotive parts & accessories stores"))
SELECT [2004 Retail].NAIC, [2004 Retail].[ZIP Code], [2004 Retail].[Total Establishments], [2004 Retail].[1-4], [2004 Retail].[5-9], [2004 Retail].[10-19], [2004 Retail].[20-49], [2004 Retail].[50-99], [2004 Retail].[100-249], [2004 Retail].[250-499], [2004 Retail].[500-999], [2004 Retail].[1000 or more] INTO 441320
FROM [2004 Retail]
WHERE (([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers") AND ([2004 Retail]![NAIC]="441320 Tire dealers"))
and oh yeah....thanks for all the help I've gotten on this forum, I love the prompt replies that I keep getting. THANX GUYS! AND GALS!