Count Related Records

[IMmapping]

I'm coming from the GIS side, so I understand databases, but am having a horrible time with Access.

I am mapping bicycle accidents around Denver, CO for my thesis and trying to perform a count on a related table. So, first I want to know how many accidents are at each intersection. I'm following Access' help but am curious if anyone knows any better tutorials.

I've created the relationship I need, but can't comprehend my query.

Thanks,
Ian

[SoftwareMatters]

For this query all you need to add is the intersection and the accident columns. Do a group by on the intersection column and a count on the accident column.

[IMmapping]

Thanks for the fast response, I knew the theory but you explained it simple enough so I could figure it out! Now it's about to get a lot more complicated...

[IMmapping]

I played with that a bit last night, but now I need to count a bunch of things on a related record. I will be counting types of parcels on a street. Do I have to create separate queries for each parcel type?

Thanks,
Ian