Apologies, this should work.

select tI.mm/yy,

 Total Loan amount of loans closed,

 Count of loans closed,

 Total Loan amount of Applications,

  Count of applications

from

(

select mm/yy,

 sum(Loan amount) as total...

Try this, I have not tested but nested queries in this situation should work well.

select mm/yy,

 Total Loan amount of loans closed,

 Count of loans closed,

 Total Loan amount of Applications,

  Count of...

Thank you master.

We installed Crystal reports & enterprise connected to a SQL database. Our Crystal enterprise server is running on a separate server. It is working beautifully. We use...