Count years in date range

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello, all. I have two columns in a table; one name StartDate, the other
EndDate. Each table refers to a user and details, obviously, their start
date and end date. Those who have not ended have a null value. To the
question...

I need to count the number of users in each year. For example:

User 1: Start Date: 04/15/1990, End Date: 06/08/1995
User 2: Start Date: 09/08/1993, End Date: 04/25/1995
User 3: Start Date: 10/15/1995, End Date: 12/06/1996

The year count should be: 1990 (1), 1991 (1), 1992 (1), 1993 (2), 1994 (2),
1995 (3), 1996 (1).

My user count is 2,000+. Any help would be greatly appreciated.
.

Relevant Pages