Well that actually isn't going to work... I think what I need is some kind of IF THEN statement where member number is the same and loan type is the...

That is getting me closer. I do need to keep the loan type as is because that is what we use for the report. We list all the loans by...

I do need all of the columns in the group statement. I just need one row entry for each of the same member numbers where  loan type is the same...