It hardly takes any time at all. The craziness that runs immediately before takes just shy of 2 minutes and when I add this afterwards it was still finished at...

Yes, we only ever have Ds and Fs. This is perfect - thank you so much!!!

Apologies! No, that's an oversight on my part. Here is the corrected sample data and attached example result set:

SELECT 140675885, 072915107, 1580, 'D' UNION ALL

SELECT 140675886, 072915107, 11 , 'D' UNION ALL

SELECT 140675887, 072915107, 1580, 'D' UNION ALL

SELECT 140675888, 072915107, 109 , 'D' UNION...

Thank you, Dwain - good to know!

Ahhh! Thank you so much, Jeff!! I've used crosstab before, but didn't realize that's what that was called. Scary, right? I feel like a kid who drops a perfectly good...

Thank you all for your replies!

Tom, you have it correct. There are, at times, gaps in the BorrowerOrder numbers, and there are times when there might be up to...

Hi everyone - I was finally able to solve the filter for this! Am posting the expression below in case anyone else needs help with this.

In the Filter expression:

Expression:

=IIF(Parameters!Loan.Value...

Thanks, Ray! I agree, I'm leaning towards #1 as well. I've added this to the code, but now I'm stumped on the expression to use in the List filter so...