I have point data (about 1000 points) in a .mdb. One of the columns within the database is "State", and when I ran the "Split by Attribute" tool by state the new returned records were correctly split by state.
I then added a new column to the database, "Sample_Year" in which every point was assigned either 'Year 1', 'Year 2', 'Year 3', 'Year 4', or 'Year 5'. When I ran the 'Split by Attribute' tool to split the points by "Sample_Year", 5 records were returned, correctly named ("Year 1', "Year 2...) but the attribute table for each record was empty and no points were actually plotted on my map.
Any ideas on what might be causing the empty return?
I believe I'm using the tool correctly as the first time I tried it with an existing column it worked correctly. I've tried it on other existing columns since, and those all work too. It's just this new column that I've created that returns empty attribute tables and no data.
I'm new to ArcGIS.