Crosstab Query

[Guest]

Please help. I’m still learning… I created a crosstab query which gives part
of what I need. Fields are [Vendor], [Status] (counts loans approve, denied,
or withdrawn), [VendorID] (total loans by vendor), and [CurrentLoan] (total
loan amount by vendor). The result is:

Vendor Approved Denied Withdrawn Total Count CurrentLoan
Vendor 1 6 0 2 8
$xxx,xxx.00
Vendor 2 8 1 0 9
$xxx,xxx.00

I also need the sum of CurrentLoan broken down by Approved, Denied and
Withdrawn by Vendor. Can I accomplish this from the query? If not, can I get
it from a report? Either way, I need assistance. Thank you.

 

[[MVP] S.Clark]

I think you could add a few more columns to the crosstab(depending on the
query of which it is based) to show [Category Name Amount]

So your columns would be:
ApprovedCount
ApprovedAmount
DeniedCount
DeniedAmount
WithdrawnCount
WithdrawnAmount
TotalCount
TotalAmount
CurrentLoan

Like I said, you'll probably need to modify the query of which the crosstab
query is based, or make one.