Results 1 to 6 of 6
  1. #1
    BenHPieters is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Location
    Johannesburg
    Posts
    10

    How do I report on captured data records in 3 dimensions?

    I want to create a few tables to handle the following scenario in my view:

    Multiple shareholders attending a meeting (reading from a shareholder table look-up) where
    multiple resolutions are considered and voted upon (reading from a meeting table listing the resolutions), and
    each shareholder can potentially vote any one of 3 different ways per resolution (using a numeric indicator for each voting option per resolution).

    I then want to report in total per resolution on the different votes cast.



    Please help....

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Perhaps something like this

    tblShareholders
    ShareholderPK
    ShareholderName

    tblMeetings
    MeetingPK
    MeetingName
    MeetingDate

    tblResolutions
    ResolutionPK
    MeetingFK
    ResolutionName
    ResolutionDetail

    tblVotes
    VotePK
    ShareholderFK
    ResolutionFK
    Vote

    Not sure you have provided enough detail - can all shareholders vote in all meetings for example?
    Assumption is resolutions are unique to a meeting - but subjects such as directors remuneration may be made in multiple resolutions

  3. #3
    BenHPieters is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Location
    Johannesburg
    Posts
    10
    Thanks Ajax.
    Yes all shareholders can either vote or abstain from voting at all meetings. Different meetings have different resolutions to be voted on, unique to such meeting.
    As I see it the key detail would be the type of record captured in the Vote table per your example. I thought of a crosstab on that table to count the different types of votes. Would that work?

  4. #4
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    don't see why not, resolution would be row header, vote would be column header, count vote would be value

    Something else to consider - are members invited to meetings? do they have to register on arrival? what about proxy votes etc

  5. #5
    BenHPieters is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Location
    Johannesburg
    Posts
    10
    Thanks Ajax,
    The only other aspect is that shareholders can file a proxy instead of attending and voting, but would be handled the same way as a person attending and voting.
    Not planning to cater for registrations etc.
    Will build your approach and revert if I have difficulties.

  6. #6
    BenHPieters is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Location
    Johannesburg
    Posts
    10
    Hi Ajax,
    Yes it works with a small test. Will not proceed to build the model.
    Thanks for your assistance.
    Appreciated.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Form Me. Values aren't getting captured in Loop
    By Enrightt in forum Programming
    Replies: 1
    Last Post: 10-05-2018, 02:51 PM
  2. Replies: 5
    Last Post: 12-01-2017, 01:40 PM
  3. querying for dimensions
    By btappan in forum Access
    Replies: 7
    Last Post: 04-25-2017, 02:58 PM
  4. Replies: 6
    Last Post: 10-01-2013, 08:23 AM
  5. Package dimensions query
    By aflamin24 in forum Queries
    Replies: 3
    Last Post: 10-23-2012, 07:26 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums