Never mind, I think I got it. I removed 'sum' from the beginning of the case statement so it would give fiscal year totals for each recipient.

I hope you're still out there Lutz.... I'm looking at my results in detail and something's not quite right.

I'm running just for one fund (field Grants.FundNumber) and one fiscal...

I'm back. The data looks good, but I can't seem to get my mind around the report. I'm using visual studio and selected a matrix from the toolbox...

Ok, good! It would kinda suck to find the site that helps with all my SQL needs, then get kicked off for being ridiculous.

I love all the input and...

Sorry - didn't mean to be unprofessional. You just have NO IDEA how long I was struggling with this issue. I just wish I found this forum a...

Wow. I think that is the answer. I'll mess with the whole report tomorrow. Thanks Lutz, my new BFF.

Best site ever.

Thanks for the reply. I think I understand your statement. I tried putting it in my overly complicated query (below) and received an error (SELECT not recognized). ...