So basically, I've got employee data within quarter-mile grids for different states. So there is a grid covering the entire state, each grid 1/4 mile apart, with a employee data within each of those 1/4 squares. The data represents the entire 1/4 mile, it's not individual points.
I then also have 1 mile buffers around different cities throughout those states.
I need to determine how many employees are within each of those buffers. However, whenever I append the grids to the buffers, it counts the ENTIRE grid, even if a portion of it goes outside that buffer. I need it so it does not include any data outside of the buffer.
I have tried to use both the clip and intersect tool. Both tools did clip the grids spatially, but they did not change the data in terms of numbers of employees whatsoever.
Any ideas?