Results 1 to 2 of 2
  1. #1
    Roy Hobbs is offline Novice
    Windows 7 32bit Access 2013 32bit
    Join Date
    Mar 2016

    Data Organization - Tables-Queries Set Up

    I have tried to set up my data a couple of different ways but I seem to keep reaching the same road block. I can visualize my end report but can't get there.

    My data is confidential work related but let me use an equivalent example. I am trying to create a database that tracks the winning bidder of the Olympics along with 2 losing bidders.

    Year Winner Loser1 Loser2
    2018 Winter Pyeonchang Munich Annecy
    2016 Summer Rio Chicago Tokyo
    2014 Winter Sochi Salzburg Pyeongchang
    2012 Summer London Moscow Paris

    2010 Winter Vancouver Pyeongchang Salzburg

    Ultimately, I want to create a winning percentage for each city. Though this data is skimpy, Pyeonchang is a good example of my troubles. It has 1 winning bid and 2 losing bids, and also the losing bids are in 2 different columns.

    Any suggestion?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    The way you show the data is not how you store it. But that is the end result.
    the table is:
    year, person, place

    then, a query would pull the top 3.
    the use a Crosstab to get your report above.

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

Similar Threads

  1. Replies: 17
    Last Post: 06-13-2014, 10:25 AM
  2. Replies: 2
    Last Post: 07-24-2013, 01:29 PM
  3. Relationships/Data Organization
    By mixfeat in forum Access
    Replies: 2
    Last Post: 03-28-2011, 03:55 PM
  4. Report organization
    By kstyles in forum Reports
    Replies: 7
    Last Post: 01-10-2011, 02:47 PM
  5. Adding data to tables using queries
    By HunterEngineeringCoop in forum Queries
    Replies: 3
    Last Post: 10-28-2010, 12:42 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