• Without DDL and sample data, here's my first thought:

    SELECT YearRecruited, Hospital, Jan, Feb, Mar, Apr, May,

    Jun, Jul, Aug, Sep, Oct, Nov, Dec, MyCounter,

    (Jan + Feb + Mar + Apr + May + Jun + Jul + Aug + Sep

    + Oct + Nov + Dec) AS Total

    FROM (

    SELECT * FROM (

    SELECT YEAR(DateFormCompleted) AS [YearRecruited], Hospital,

    left(datename(month,DateFormCompleted),3) AS [Month],

    PersonCounter AS MyCounter

    FROM tblPerson p

    JOIN tblManagementOfBleeding m

    ON m.SubjectNumber = p.SubjectNumber)

    AS s

    PIVOT (

    COUNT(MyCounter) FOR [Month] IN (

    Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec

    ))AS p )

    ORDER BY YearRecruited ASC, Hospital ASC

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.