I have a table that evaluates shared voting control. Greatly simplified, the records look like this:
Shares, Owner, Proxy, Trustees, Trustee1, Trustee2, Trustee3, Trustee4
100, A, A,
125, A, Shared, A, A,
100, A, Shared, B C, B, C
800, A, Shared B C D E, B, C, D, E
I need to report how voting is shared on a pro-rata basis, grouped by Proxy, except that in the case of Trusts, proxy sharing is determined by the number of trustees, without duplication. My output from the above would look like this:
Proxy
A 100
A 125
A 200
B 50
B 200
C 50
D 200
E 200
Total 1,125
I can't figure out how to divide data in a record into multiple subsets (my four records neet 8 lines to print). Is it possible to evaluate both the "proxy" and "trustee" fields in a report or a query and get them to a single output?
I know I could dump it into excel, but there are many other queries and reports that make Access the better chouce.
Thanks for any insight.
Shares, Owner, Proxy, Trustees, Trustee1, Trustee2, Trustee3, Trustee4
100, A, A,
125, A, Shared, A, A,
100, A, Shared, B C, B, C
800, A, Shared B C D E, B, C, D, E
I need to report how voting is shared on a pro-rata basis, grouped by Proxy, except that in the case of Trusts, proxy sharing is determined by the number of trustees, without duplication. My output from the above would look like this:
Proxy
A 100
A 125
A 200
B 50
B 200
C 50
D 200
E 200
Total 1,125
I can't figure out how to divide data in a record into multiple subsets (my four records neet 8 lines to print). Is it possible to evaluate both the "proxy" and "trustee" fields in a report or a query and get them to a single output?
I know I could dump it into excel, but there are many other queries and reports that make Access the better chouce.
Thanks for any insight.