Report Help

[clueless]

I need a little direction (maybe a lot, actually) for building a new
report. I thought I could get the results I need with a simple
crosstab query, but I was wrong.

The report should have the following:

column headings: LoanStatus (for column headings - there are
several)
subcolumn headings: Count (# Loans by status) and $ Amount (Sum for
Loans by status)
row headings: ClientName (i only want the name of each
client to appear once)

Finally, I would like to have a grand total for each client by each
status at the bottom.

Is there anyone that can help me out with this problem?

Thanks.

 

[clueless]

Since I haven't had any responses, should I assume that my post doesn't
make any sense or that it's a dumb question or that no one knows how to
accomplish this request? If I have been unclear, then let me know and
I'll offer more detail. I could definitely use some help. Thanks.