R
Robin W
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.
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.