Having trouble doing a choropleth map

[LaurieMilord]

I keep getting "Source table must have an ObjectID column to perform a join by location" What?
Ive never gotten this before...using ArcView 10

I can do the map in reverse by using my response Areas (polygon) layer and then joining my crime data to it, but it doesn't look like it is counting the data correctly.

I cannot get it to work the correct way. I have tried an excel spreadsheet and a direct database connection to my access database, I have added an numbered field in excel and included the activity ID number in my access Qry (which is a unique auto number). I renamed this field ObjectID but still cannot get past this.....what am I missing.

Thanks, Laurie

[JoeBorgione]

I keep getting "Source table must have an ObjectID column to perform a join by location" What?
Ive never gotten this before...using ArcView 10

I can do the map in reverse by using my response Areas (polygon) layer and then joining my crime data to it, but it doesn't look like it is counting the data correctly.

I cannot get it to work the correct way. I have tried an excel spreadsheet and a direct database connection to my access database, I have added an numbered field in excel and included the activity ID number in my access Qry (which is a unique auto number). I renamed this field ObjectID but still cannot get past this.....what am I missing.

Thanks, Laurie

Laurie-  look at what it's telling you and what you've posted: No OID and Excel....  Give this a try; import your excel spreadsheet into some flavor of geodatabase and you'll get a real live object id.

Hope this helps...