Yes, it should show for all 4 years for member type 3 (Collegiates)
I thought it is. will check.
It looks good. Thank you for all your help!
Your query with the correction I gave, works fine here, on the sample data you provided earlier.
Please show us the whole error, the query you run against production and the create statement of the tables from your production.
this is a really helpful forum...